I give sales quotes using the same Excel worksheet but save each new one
under the person's last name. They are all saved in a folder called "Sales
Quotes 2006". Is it possible to query those saved files and extract data from
them, not individually but at the same time. In other words, retrive data
from all the sales quotes for 2006 and then make a report in a new worksheet
based on information contained in each file?

--CK

Maybe have a look at Ron de Bruin's site for code to pull data from all
workbooks in a folder.

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


Gord Dibben MS Excel MVP



On Wed, 15 Nov 2006 16:38:01 -0800, ck wrote:

I give sales quotes using the same Excel worksheet but save each new one
under the person's last name. They are all saved in a folder called "Sales
Quotes 2006". Is it possible to query those saved files and extract data from
them, not individually but at the same time. In other words, retrive data
from all the sales quotes for 2006 and then make a report in a new worksheet
based on information contained in each file?

--CK

Thanks Gord. This gets me in the right direction. --
CK

"Gord Dibben" wrote:

Maybe have a look at Ron de Bruin's site for code to pull data from all
workbooks in a folder.

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


Gord Dibben MS Excel MVP



On Wed, 15 Nov 2006 16:38:01 -0800, ck wrote:

I give sales quotes using the same Excel worksheet but save each new one
under the person's last name. They are all saved in a folder called "Sales
Quotes 2006". Is it possible to query those saved files and extract data from
them, not individually but at the same time. In other words, retrive data
from all the sales quotes for 2006 and then make a report in a new worksheet
based on information contained in each file?

--CK