Hi everyone,

I am really running this past people before I start writing code to
ensure I can actually do this one way or another.

I am wanting to write a macro in a sheet that finds a certain cell in
every excel file in a folder and sums them up. Sounds simple but am I
kidding myself?

Hi Keri

Look here
http://www.rondebruin.nl/summary2.htm

This example create a formule link to each file.
You can use a simple Sum formula now to get what you want


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"keri" wrote in message ups.com...
Hi everyone,

I am really running this past people before I start writing code to
ensure I can actually do this one way or another.

I am wanting to write a macro in a sheet that finds a certain cell in
every excel file in a folder and sums them up. Sounds simple but am I
kidding myself?

Super thanks.

I think my main problem is going to be that I want the macro to
automatically search for new files in the specified folder every time
the work book is opened. I didn't explain this very clearly.

At the moment I store order form in a folder called orders. I currently
have to take the total from each order workbook and manually enter it
into a tracker. I save a new order workbook approx once a week.

The code to get a sum from a destination I can specify is simple. But I
am unsure how to sum from all files in the folder.


Ron de Bruin wrote:
Hi Keri

Look here
http://www.rondebruin.nl/summary2.htm

This example create a formule link to each file.
You can use a simple Sum formula now to get what you want


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"keri" wrote in message ups.com...
Hi everyone,

I am really running this past people before I start writing code to
ensure I can actually do this one way or another.

I am wanting to write a macro in a sheet that finds a certain cell in
every excel file in a folder and sums them up. Sounds simple but am I
kidding myself?