G
Guest
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
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