Consolidate multiple workbooks

[Guest]

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

 

[Randall Senn via OfficeKB.com]

Short answer, yes.

See the file at this link for a simple sample.

http://www.anywhereenterprises.com:80/1/1/a?a=dF&p=sOWqqzY5isOWOAApQZOAAy7P

 

[Ron de Bruin]

Hi BillMarshall

See

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