Information from numerious excel worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How would I get infromation from different .xls files? I am working with
numerious .xls files which contain simialar colomns. Each sheet has a column
for 2005, 2006, 2007, 2008. Is there a wayto get inforamtion from the "Total"
row lining up with the year from each sheet? Each sheet is from different
..xls files. This is all being done through a macro.
 
BZeyger,

Yes information can be retrieved from various workbooks. What do you mean
"This is all being done through a macro." Can you post the macro if there is
one?
 
The macro would be on a blank excel sheet. The user would have to select the
nemerious .xls files to open. There will be information gathered from each
..xls file and inserted into the blank worksheet with the macro.
 

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

Macro imports data into cols A,B,C. Would like the data in D,E,F 3
Put worksheet names from inactive file into cells of active worksh 2
Sub to stack data n paste unique order ID lines 3
excel 2003 vs 2007 menu and sheet issues 3
Copy Data from Closed File to Existing File 0
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Getting info from all .xls files which are open 5
Using a string variable to change a file name 2

Back
Top