How do I pull information from multiple existing spreadsheets int.
 

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

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

JJohn wrote:

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

--

Dave Peterson

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.

"JJohn" wrote:

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

"JJohn" wrote in message
...
I need to pull information from multiple spreadsheets into a new
spreadsheet
to develop a monthly recap.


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

Hi John

I have some examples on my site
Copy examples and formulas

http://www.rondebruin.nl/tips.htm



--
Regards Ron de Bruin
http://www.rondebruin.nl



"JJohn" wrote in message ...
I need to pull information from multiple spreadsheets into a new spreadsheet
to develop a monthly recap.