| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pulling data from multiple workbooks
I have something on the range of 50 or so different workbooks. There are
multiple worksheets within these workbooks, but I am only concerned with Sheet1. Is there a way to compile all these different Sheet1's into one single work book and pasting them as values. All the workbooks of intrest reside in the same folder so there are no subfolders. Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from multiple files | Excel Discussion (Misc queries) | |||
| Pulling data from multiple spreadsheet | Excel Worksheet Functions | |||
| Pulling data from multiple rows and columns | Excel Worksheet Functions | |||
| pulling data into a master sheet from multiple worksheets | Excel Worksheet Functions | |||
| Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
Threaded Mode
