Macro to copy and append spreadsheet changes to new spreadsheet

J

Journey

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?
 
R

Rich57

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export tracked changes to a new document 0
Add additional information to excel form after original data entry 0
Task Information Dialog Box not making duration changes to task 0
Need Help with Macro Security 1
How to automate update on weekly reports spreadsheet 0
Auto Populate One Pages from spreadsheet 0
Setting column width in a table with a macro is not working 0
Append Crosstab Query to Existing Table 0

Top