Copy & Delete Rows to Another Sheet

**cindy1971** · 09-08-2008, 01:39 PM

I have a spreadsheet named GTD Week #XX with approximately 6 columns and multiple rows. Upon entry of a specific value (Done, Complete, whatever) in the right most column, I need the row to be deleted and moved to a sheet called "Log" in the same workbook. I need to be able to copy this sheet and change the week # each time, but all deleted rows should be added to the same sheet, "Log."

I know it's a lot to ask but can anyone help me with this?

Thanks,
Cindy

**VBA Noob** · 09-08-2008, 03:31 PM

This link should get you started

http://www.rondebruin.nl/copy5.htm#Add

VBA Noob

**cindy1971** · 09-09-2008, 09:25 AM

Thanks for the help. Do you know of a script I could adjust (I'm relatively new to it and not confident enough to build it myself yet) that would delete the row once I enter complete instead of just pasting it? Also one where "Complete" rows would go to one sheet, "Defer" rows would go to another sheet, etc. I'll have about five criteria and each needs to go on a different sheet. (Boss keeps adding to the project!)