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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message news:[email protected]...
>I need to pull information from multiple spreadsheets into a new spreadsheet
> to develop a monthly recap.