Automatically copy new data to different worksheet
 

We have a worksheet that has a large amount of data that changes, where rows
of data are inserted and deleted when finished with. We want a second
worksheet that has just the first few columns of each new row that is
inserted to keep and save as an archive. Is it possible to automatically copy
a few columns of every new row of data added in sheet1 as a permanent record
in sheet2 ?

Automatically copy new data to different worksheet
 

See Ron de Bruin's site for copy/paste/merge example code for moiving data to a
database.

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


Gord Dibben MS Excel MVP

On Thu, 8 May 2008 02:18:00 -0700, stretch
wrote:

We have a worksheet that has a large amount of data that changes, where rows
of data are inserted and deleted when finished with. We want a second
worksheet that has just the first few columns of each new row that is
inserted to keep and save as an archive. Is it possible to automatically copy
a few columns of every new row of data added in sheet1 as a permanent record
in sheet2 ?