Hi ,
In the attached file, a macro moves the row from the Current Data worksheet to the Archive sheet when the status is changed from Current to Complete.
I would only like to paste the values & formatting for these rows, not any formulae.
Any ideas on how I can tweak the code?
Thanks in advance...
Bookmarks