software

You can start here
www.rondebruin.nl/copy3.htm
--
Regards Ron de Bruin
www.rondebruin.nlquot;Marina Limeiraquot; gt; wrote in message ...
gt;I have 120 equal format files about hospital produces in cities.
gt;
gt; example: group files.xls are territories files name
gt;
gt; City item peoples
gt; A item01 100
gt;
gt; B item02 183
gt; item03 432
gt; Total
gt; C item04 34
gt;
gt;
gt; Are you send oppinion about I imagine create a big database with import from 120 files .xls
gt; to analysing...
gt;
gt; territory | city | item | people
gt; 1 A 01 100
gt; 1 B 02 183
gt; 1 B 03 432
gt; ...
gt; 3 A 01 343
gt; 3 A 02 433
gt;
gt; Question, also example from VBA to import from several files.xls to big centralize file database sheet ?
gt;
gt; thanks for helping me
gt;
gt; Marina
gt;
gt;
I have 120 equal format files about hospital produces in cities.

example: group files.xls are territories files name

City item peoples
A item01 100

B item02 183
item03 432
Total
C item04 34Are you send oppinion about I imagine create a big database with import from
120 files .xls
to analysing...

territory | city | item | people
1 A 01 100
1 B 02 183
1 B 03 432
....
3 A 01 343
3 A 02 433

Question, also example from VBA to import from several files.xls to big
centralize file database sheet ?

thanks for helping me

Marina