| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2003 - Copy Down Function to Reference Next Worksheet
Hi All,
Formula in Worksheet 1, cell A1 = 'Worksheet 2'!B2 How can I copy the above formula down to Worksheet 1, cell A2 such that it references: 'Worksheet 3'!B2 Thank you, Larry |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 - Copy Down Function to Reference Next Worksheet
Enter this formula in A1 and copy down as needed:
=INDIRECT("'Worksheet"&ROWS(A$1:A2)&"'!B2") -- Biff Microsoft Excel MVP "Lmarsh1693" wrote in message ... Hi All, Formula in Worksheet 1, cell A1 = 'Worksheet 2'!B2 How can I copy the above formula down to Worksheet 1, cell A2 such that it references: 'Worksheet 3'!B2 Thank you, Larry |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 - Copy Down Function to Reference Next Worksheet
Thanks. This will work if I have a number of sheets that I'm working with?
I need to copy this formula down in sheet 1 ( each row in sheet 1 would reflect the value in a specific cell from each worksheet ) to pull the corresponding values from the other worksheets. Will this still work so that each copy down references the next worksheet? Thx. Larry "T. Valko" wrote: Enter this formula in A1 and copy down as needed: =INDIRECT("'Worksheet"&ROWS(A$1:A2)&"'!B2") -- Biff Microsoft Excel MVP "Lmarsh1693" wrote in message ... Hi All, Formula in Worksheet 1, cell A1 = 'Worksheet 2'!B2 How can I copy the above formula down to Worksheet 1, cell A2 such that it references: 'Worksheet 3'!B2 Thank you, Larry |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel 2003 - Copy Down Function to Reference Next Worksheet
If you sheets do have a <space between the name and the number,
just add a space to Biff's suggestion after the name: =INDIRECT("'Worksheet "&ROWS(A$1:A2)&"'!B2") -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lmarsh1693" wrote in message ... Thanks. This will work if I have a number of sheets that I'm working with? I need to copy this formula down in sheet 1 ( each row in sheet 1 would reflect the value in a specific cell from each worksheet ) to pull the corresponding values from the other worksheets. Will this still work so that each copy down references the next worksheet? Thx. Larry "T. Valko" wrote: Enter this formula in A1 and copy down as needed: =INDIRECT("'Worksheet"&ROWS(A$1:A2)&"'!B2") -- Biff Microsoft Excel MVP "Lmarsh1693" wrote in message ... Hi All, Formula in Worksheet 1, cell A1 = 'Worksheet 2'!B2 How can I copy the above formula down to Worksheet 1, cell A2 such that it references: 'Worksheet 3'!B2 Thank you, Larry |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If you sheets do have a <space between the name and thenumber,just add a
To complicate this scenario further, at the end of ech week I develop a sheet named for the year, month, and last day of the week (eg. 20120618). An annual total sheet (AT) already exists, and at weeks end I need to create a new column in the AT sheet and reference the same cell from the week before, but in the new week on the AT page. It would be nice to drag to the new column in the AT sheet and have the cells referenc the new week. Any thoughts?
On Friday, July 18, 2008 1:06 PM Lmarsh169 wrote: Hi All, Formula in Worksheet 1, cell A1 = 'Worksheet 2'!B2 How can I copy the above formula down to Worksheet 1, cell A2 such that it references: 'Worksheet 3'!B2 Thank you, Larry On Friday, July 18, 2008 1:26 PM T. Valko wrote: Enter this formula in A1 and copy down as needed: =INDIRECT("'Worksheet"&ROWS(A$1:A2)&"'!B2") -- Biff Microsoft Excel MVP On Friday, July 18, 2008 1:59 PM Lmarsh169 wrote: Thanks. This will work if I have a number of sheets that I'm working with? I need to copy this formula down in sheet 1 ( each row in sheet 1 would reflect the value in a specific cell from each worksheet ) to pull the corresponding values from the other worksheets. Will this still work so that each copy down references the next worksheet? Thx. Larry "T. Valko" wrote: On Friday, July 18, 2008 2:38 PM RagDyer wrote: If you sheets do have a <space between the name and the number, just add a space to Biff's suggestion after the name: =INDIRECT("'Worksheet "&ROWS(A$1:A2)&"'!B2") -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Lmarsh1693" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy function with Excel 2003 not performing correctly | Excel Worksheet Functions | |||
| Unable to Insert Worksheet/Move and copy worksheet Excel 2003 | Excel Worksheet Functions | |||
| Excel 2003 - Copy Cell Reference | Excel Worksheet Functions | |||
| Excel 2003 worksheet name function? | Excel Worksheet Functions | |||
| Excel 2003 Multi-worksheet copy via drag/drop | Excel Worksheet Functions | |||
Linear Mode
