| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summary Worksheet from Multiple Workbooks
I need a function or VBA macro that will allow me to pull data located in the
same cells in different workbooks. Each row of the summary sheet should correspond to a different workbook. The structure of each row looks like this: Path Col 1 Col 2 c\My Docs\[File 1] Path&Sheet1'!$C$5 Path&Sheet3'!$Z$10 Any suggestions? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Organizing Multiple Workbooks | Excel Discussion (Misc queries) | |||
| AHHHH-Get Data from Multiple Excel workbooks | Excel Discussion (Misc queries) | |||
| Combine contents of multiple workbooks into one worksheet | Excel Worksheet Functions | |||
| Multiple Workbook Data Capture Summary Sheet | Excel Discussion (Misc queries) | |||
| Automatic updating worksheet data between different workbooks | Excel Worksheet Functions | |||
Threaded Mode
