Formula Help
 

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?

Formula Help
 

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?

Formula Help
 

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.

"Khoshravan" wrote:

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?

Formula Help
 

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

Copy down as needed.

Erika wrote:
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.

"Khoshravan" wrote:

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?

Formula Help
 

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

"Glenn" wrote:

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

Copy down as needed.

Erika wrote:
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.

"Khoshravan" wrote:

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?

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


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

"Glenn" wrote:

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

Copy down as needed.

Erika wrote:
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.

"Khoshravan" wrote:

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?

Formula Help
 

Amazing!! Thank you so much for your help.

"Glenn" wrote:

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 wrote:
I am getting a Value error with that formula - any ideas?

"Glenn" wrote:

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

Copy down as needed.

Erika wrote:
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.

"Khoshravan" wrote:

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?

Formula Help
 

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

Erika wrote:
Amazing!! Thank you so much for your help.

"Glenn" wrote:

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?

Formula Help
 

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.

"Glenn" wrote:

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

Erika wrote:
Amazing!! Thank you so much for your help.

"Glenn" wrote:

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?

Formula Help
 

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.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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

"Glenn" wrote:

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

Copy down as needed.

Erika wrote:
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.

"Khoshravan" wrote:

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?
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Erika" wrote:

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?