View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Journey Journey is offline
external usenet poster
 
Posts: 4
Default 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