| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Collect data from spesific cell in multiple sheets
hi Espen
On your Sum sheet, enter the list of your sheet names 01.01 to 31.12 in cells A1:A365 In B1 enter =INDIRECT("'" & A1 &"'!A1") and copy down -- Regards Roger Govier Espen Rostad wrote: Thank you Mike, but I need all results in a row. Eg Sheet '1.1' cell A1 in Sheet 'SUM' A1, Sheet '2.1' cell A1 in Sheet 'SUM' A2 .. and so on Mike H skrev: |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Collect data from spesific cell in multiple sheets
Thank you Roger - that did it
Roger Govier skrev: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can collect data from multiple sheets in the same workbook? | Excel Discussion (Misc queries) | |||
| Collect data of several sheets on another book's singel sheet | Excel Discussion (Misc queries) | |||
| How can I retrieve data from the same cell, from multiple sheets? | Excel Worksheet Functions | |||
| same data from one cell copy to multiple sheets | Excel Worksheet Functions | |||
| chart data from same cell on multiple sheets | Charts and Charting in Excel | |||
![Roger Govier[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
