I am wondering if two seperate macros are possible that
1>Copy the entire Row if the Column C Contains "Completed" in a new sheet called "Done"
I mean will append the new rows if the macro is run again. Without duplicating and update if already existed. Column B contains unique serial number.
another macro when run
2>That will clear the contains from Row C to M if the Column C Contains "Completed" in the entire sheet.
Any help is much appreciated.
Thanks in advance,
Bookmarks