| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and Append Macro | Excel Discussion (Misc queries) | |||
| How to use a macro to copy a picture from another spreadsheet | Excel Worksheet Functions | |||
| How to copy the same formulas in a spreadsheet -Macro? | Excel Worksheet Functions | |||
| Macro that will Cut rows and then insert-copy or append | Excel Discussion (Misc queries) | |||
| How do I append imported text down an Excel Spreadsheet? | Excel Worksheet Functions | |||
Linear Mode
