If I have many workbooks in the same folder, each with the same structure so
that data is in the same cell in each workbook, can I analyse the data
without individually specifiying each workbook ?

If I add a new workbook into the folder (same format), can I get the
analysis to auto update ?

...hope someone can help..

tia

Bill

Short answer, yes.

See the file at this link for a simple sample.

http://www.anywhereenterprises.com:8...OWOAApQZOAAy7P

BillMarshall wrote:
If I have many workbooks in the same folder, each with the same structure so
that data is in the same cell in each workbook, can I analyse the data
without individually specifiying each workbook ?

If I add a new workbook into the folder (same format), can I get the
analysis to auto update ?

..hope someone can help..

tia

Bill

--
If I could sign my name is there where I would do it?

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200511/1

Hi BillMarshall

See

http://www.rondebruin.nl/copy3.htm
or with formulas
http://www.rondebruin.nl/summary2.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"BillMarshall" wrote in message ...
If I have many workbooks in the same folder, each with the same structure so
that data is in the same cell in each workbook, can I analyse the data
without individually specifiying each workbook ?

If I add a new workbook into the folder (same format), can I get the
analysis to auto update ?

..hope someone can help..

tia

Bill