I would think that you could refresh all the data--no matter if it's updated or
not.

If the summary didn't change, it'll still be copied into the new worksheet.

If that's ok, Ron de Bruin has tons of samples to combine worksheets from
different workbooks at:

http://www.rondebruin.nl/copy3.htm



a94andwi wrote:

Hello.

In my work I collect info from 10 individual workbooks from 10 material
controllers.
Each one of the material controllers summarize their suppliers part
number and which parts that goes out of stock in the next three days.

Each afternoon one person summarize all of the ten workbooks and filter
out which production line that will be out of parts in these three
days.

I am trying to do a script that copys the info written on each one of
the material controllers workbook into one new workbook. Each one of
the material controllers workbook get copied onto a new worksheet in
the new workbook.

This is how far I have gotten.

Here's my question:

On one worksheet I will summarize all ten worksheets.
I want to have a macro that loops through the first worksheet and copys
the info if the info on the worksheet is updated on the current day.
This information is written on each of the material controllers own
workbook and copied.

If the worksheet is updated I want excel to copy a cell range (A1:L1)
and so on to the worksheet where the summarize is being made.

Because of the fact that there might be written cells already in the
summarize worksheet it can't be over written. It must copy the value to
clear cells.

If someone can provide a script for me to deal with I would be very
glad and it would make my life a little easier.

Best regards

/Anders

--
a94andwi
------------------------------------------------------------------------
a94andwi's Profile: http://www.excelforum.com/member.php...o&userid=21077
View this thread: http://www.excelforum.com/showthread...hreadid=386117

--

Dave Peterson