Formula Help

[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?

 

[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?

 

[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.

 

[Glenn]

=INDIRECT(TEXT(DATE(2008,ROW(A1),1),"mmm")&"!J34")

Copy down as needed.

 

[Erika]

I am getting a Value error with that formula - any ideas?

 

[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?

 

[Erika]

Amazing!! Thank you so much for your help.

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?

 

[Glenn]

What about that was "Amazing"? Did you find the problem?

 

[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.

 

[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.