Macro to copy and append spreadsheet changes to new spreadsheet

Macro to copy and append spreadsheet changes to new spreadsheet

Post by Sm91cm5le » Sat, 14 Jun 2008 22:15:01


I have a working spreadsheet, spsht1, and a summary spread sheet spsht2.
Spsht 2 does not have all the columns as spsht2. I would like to create a
macro to update spsht2 so that when I make changes to the rows in spsht1 or
add additional rows, I can copy these changes and then append them to spsht2
but for only the columns that are in spsht2. Can anyone help?
--
jsm
 
 
 

Macro to copy and append spreadsheet changes to new spreadsheet

Post by UmljaDU » Sun, 15 Jun 2008 00:33:24

Would this alternative approach achieve the same ends: Save spsht1 as spsht2
and hide the columns that are not required. If so, why not create two macros
and use one spreadsheet only. One macro hides the unwanted columns, and the
macro restores them.
Have I missed something, or have you not told me something?
--
Richard

Search the web and raise money for charity at http://www.yqcomputer.com/