Macro to copy and append spreadsheet changes to new spreadsheet
 

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
 

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.everyclick.com/


"Journey" wrote:

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