Lookup Multiple Worksheets/Workbooks
 

I would like to sum up values held in various worksheets. I am trying to
track inventory for each new purchase order created, each new purchase order
will be created by a new worksheet. In other words, I am trying to lookup
and sum values in worksheets that are not yet created. Any ideas?

Your help is appreciated.
Dave

Lookup Multiple Worksheets/Workbooks
 

Maybe this Dave
http://www.rondebruin.nl/linksum.htm

I like the sandwich example

--

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


"Dave" wrote in message ...
I would like to sum up values held in various worksheets. I am trying to
track inventory for each new purchase order created, each new purchase order
will be created by a new worksheet. In other words, I am trying to lookup
and sum values in worksheets that are not yet created. Any ideas?

Your help is appreciated.
Dave