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" wrote:

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?