Quote Originally Posted by jaslake View Post
Hi BigBlackMamba

What happens to the data on sheet1 after it's been copied to sheet2? Does it get erased? Does it stay on sheet1 and get marked as processed? If it gets marked, what column?

You indicate you want this process to run every 30 seconds. I don't know the source of the data for sheet1 and I don't know the consequences of running this procedure when sheet1 data is being updated. But, it can be done.

A sample of your data would be nice.

John

Thanks for responding.

The data in Sheet 1 is will not get erased or marked as updated - it's streaming data from a data supplier. All I'm trying to do is take a snapshot of this data as fast as possible. The second sheet will be copied to a third sheet in a summarized form and then erased from sheet 2.

I don't have any sample data to show you as yet.

Are there any limitations on how fast Excel can copy this data (from sheet1 into 2)? e.g. could this be done every second or 2 seconds?