Formula Help

E

Erika

I have a workbook that contains a worksheet for each month and then a
worksheet for 2009 totals. I have a paste link set up to look at Jan!34 I
want to copy the formula down so it goes to Feb!34, Mar!34 and continues
however when I copy the formula down I get Jan!34, Jan!35, Jan!36, etc. Is
there a fast way to get it to look at cell 34 on each worksheet?
 
K

Khoshravan

Not completely sure if this answers your question but I think you are
looking for relative and absolute references.
Try this one Jan$34.
$ sign means 34 is absolute and will not change, but I cant understand what
is Jan in Jan!34. Is this sheet name?
 
E

Erika

Sorry I missed the column letter when I copy a cell down it is copying
Jan!J34, Jan!J35 and actually need it to do Jan!J34, Feb!J34, Mar!J34. Is
there an easy what do this? I need to do this on several spreadsheets.
 
G

Glenn

Is that the entire formula in the cell? If not, show it and what is in J34 on
the referenced worksheet for the cell returning the #VALUE! error?
 
E

Erika

Amazing!! Thank you so much for your help.

Glenn said:
Is that the entire formula in the cell? If not, show it and what is in J34 on
the referenced worksheet for the cell returning the #VALUE! error?
 
E

Erika

I did not think that was possible and within a few minutes of posting I got
that answer and it worked. I was just saying thank you - yes it worked.
 
K

Khoshravan

Now I understand your question. I faced similar situation a couple of years
ago. On that time I got a reply here to use sheet name as part of reference,
but I can't recall it now and should search to find it. If you don't get
proper reply by then, I will send it with one-two days.
On this solution you get the first part of reference from sheet name which
is months, like Jan., Feb. and the second part which is constant for all
cells.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top