| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
list data of same cell on different worksheets.
Hi Titam,
I just realised it can be reduced from using two columns to just one: Sheet1!A2 has the following formula =INDIRECT("Sheet" & ROW() & "!"& $A$1) Sheet1!A1 still contains the address of the text cell that is in the same position on every sheet. The only drawback I can see is that when the common text cell is a blank cell the summary on sheet1 will be a "0" (zero) instead of blank. Ken Johnson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| Input cell reference is not valid (One Variable Data Table) | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
Hybrid Mode
