Summary Worksheet from Multiple Workbooks

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Consolidate Multiple Workbooks - Excel 2007 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Copying data to summary sheet 2
Excel 2007 - Linking workbooks 1
Compile data from several workbooks 1
USe Contents of cell as name of worksheet in a function 5
copying data to summary sheet 2
How can I pull Cell value from Detail worksheet into Summary sheet? 2

Top