| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining data from cells from several excel sheets to a new sheet
Hi,
I have a bunch of excel files, say S101.xls, S102.xls, ... S120.xls. I would like to combine data from the same cell in each sheet to one table in a new sheet. How can I do that easily? Example of the resulting table in a new sheet in a new excel file: cell b9 of sheet S101.xls - cell f11 sheet S101.xls - cell b25 sheet S101.xls - etc. cell b9 of sheet S102.xls - cell f11 sheet S102.xls - cell b25 sheet S102.xls - etc. .... cell b9 of sheet S120.xls - cell f11 sheet S120.xls - cell b25 sheet S120.xls - etc. Thanks a lot, Rik |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Importing Data | Excel Worksheet Functions | |||
| AUTO FILTER NOT CHANGING RESULTS | Excel Discussion (Misc queries) | |||
| Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
| Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
