How do I pull information from multiple existing spreadsheets int.

J

JJohn

I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap.
 
D

Dave Peterson

Maybe using formulas that point at the specific cells you want brought back???
 
I

IanRoy

Do it the same way you reference cells on the same worksheet. In Sheet1, a
reference to cell A1 on Sheet2, will look like Sheet2!A1.
 
F

Fredrik Wahlgren

JJohn said:
I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap.
Click to expand...

I have helped someone else with a macro that does this. More information
would be helpful. How are these files organized? Is there a naming
convention? What program generates them? Do you need single values or do you
want the sum of several cells?

/Fredrik
 
Top