Thread: Automatically copy new data to different worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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 ?

Reply With QuoteReply With Quote