| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copy data from one worksheet into another | Excel Discussion (Misc queries) | |||
| Copy data into another worksheet and have it update automatically? | Excel Discussion (Misc queries) | |||
| Automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
| Copy data automatically onto a separate worksheet | Excel Discussion (Misc queries) | |||
| automatically copy data from one worksheet to another | Excel Worksheet Functions | |||
Linear Mode
