Greetings, first timer so be gentle,
I have a spread sheet that uses a worksheet_change macro. I would like to either create a second macro, or in the same macro when the changes are implimented, copy the contents on the row that was changed (A-J) onto the last available line of an "ARCHIVE" page (i.e. a change tracker page).
The attempts I have tried so far capies the contents 607 times??? What am I doing wrong? Any suggestions.
Thanks,
Kizinti
I have a spread sheet that uses a worksheet_change macro. I would like to either create a second macro, or in the same macro when the changes are implimented, copy the contents on the row that was changed (A-J) onto the last available line of an "ARCHIVE" page (i.e. a change tracker page).
The attempts I have tried so far capies the contents 607 times??? What am I doing wrong? Any suggestions.
Thanks,
Kizinti