Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|