| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I get a worksheet reference to increment when copied
You can use INDIRECT
=INDIRECT("'Sheet "&COLUMNS($A$1:A1)&"'!K9") copied across -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com "RAF" wrote in message ... I have a significant number of identical worksheets that may contain different values I need to consolidate to a single worksheet. If I have a column in the consolidation worksheet that pulls data from a source worksheet using cell formulae such as: ='Sheet 1'!$K9, is there a way in which I can get this to copy into adjacent, assending columns such that the worksheet reference would be automatically incremented i.e.: ='Sheet 2'!$K9, ='Sheet 3'!$K9, and so forth? I cannot seem to find anything that is on point but I'm sure there must be a way to accomplish this. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference to Worksheet name | Excel Worksheet Functions | |||
| Copy worksheet & maintain cell reference across worksheets | Excel Worksheet Functions | |||
| How do I reference data from one worksheet to another using combob | New Users to Excel | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| How do I automatically increment worksheet number when pasting a . | Excel Worksheet Functions | |||
Threaded Mode
