Summary of Different Workbooks

[stratis]

I have about 1000 different Workbooks. EIn each one the data has the same
structure A:G but of course different rows each one.
The first thing I need to do is to create a summary line in each one
summarising the rows C:G.
Then i need to get this summary line from each one of the 1000 wokbooks and
and create a summary sheet.

Any ideas?

 

[Joel]

The firstt thing you need to do is to find each workbook and open it. You
need to tell us how the workbooks are organized (directories). Start simple
by first getting
a list of all the workbooks. Once this is done opening is pretty simple.

Next you havve to give more informattion about the summary line. It is easy
to add a row, but you need tto tell us what the worksheets names are, the
information goes on summary row and how it is calculated.

Copying the summary row to a new worbook is also simple, once the details
are given.

What you really want to do is to create a masterr workbook that will contain
your new macro. Get the path(s) of where the workbooks are located. Open
the workbooks and create the summary row. Copy the summary row to the master
workbook. close the file. Repeat.

 

[stratis]

Tks Joel
here are the details
for example lets suppose Every Workbook has one worksheet and Contains Data
for a particular salesman
A,B,C,
A B C D
Salesman, Quantity, price, Status
John, 3, 100, Final
John, 1, 50, pending

and on D1, E1, F1, G1 are the summary function that contains
D1 E1 F1 G1
Agents, Sum of Units, Sales, Final Sales
John (=A2) Sum of Units Sum(B:B), Sales (Sum(C:C)), Final Sales (Sumif
(D, "Final", C,C)

is there a way 1) To insert the function in all workbooks without opening them
2) to create a summary sheet? where I will have aline like this for every
workbook?


tks


Ο χÏήστης "Joel" έγγÏαψε:

 

[Tom Ogilvy]

see answer to your later posting.