Moving Rows into a different sheet based on a cell value

Originally Posted by Mumps1

I downloaded your file but when I went into the Visual Basic Editor, I got a message that your project is unviewable because it is a shared file. Could you post an unshared version of the file?

Hi, Thanks for the response. I've attached an editable file here Attachment 422085

Originally Posted by Mumps1

Copy and paste this macro into the worksheet code module. Do the following: right click the tab for your "Work in Progress" sheet and click 'View Code'. Paste the macro into the empty code window that opens up. I've named your destination sheet as "Work Completed". Change the name in the code to suit your needs. Close the code window to return to your sheet. When you enter "SENT" in column H and exit the cell, that row will automatically be copied to the "Work Completed" sheet and deleted from the "Work in Progress" sheet.

Please Login or Register  to view this content.

Thank you so much. That worked. Let's say someone on the staff accidently enters "SENT" and exits cell, is there a way to undo the macro?

Originally Posted by Mumps1

There is no UnDo'ing a macro. You would need another macro to put the line back. Is that what you want?

No that is fine, what you provided was more than awesome. I appreciate it.

Originally Posted by Mumps1

My pleasure.

Hey Mumps,

So I got a more difficult task assigned to me, I've been searching like crazy, maybe you can help me out with this.

So we added 3 more sheets in between the Work in Progress to the Completed Stage.

Reads like this.

1.Blast Queue
2. Follow Up Blast
3. Follow Up 2
4. Follow 3
5. Completed Blasts

Attachment 422508

I tried recreating the code by just copying it before the end of the previous sheet but that didnt work. I'm trying to get each of these works moved from 1 to 2. 2 to 3. 3 to 4. 4 to 5 (completed).

Not sure if this will pose a problem if we use the same word "SENT" as the trigger on all of these to move them along, what do you think?

Also as we move them along is there a way to program sheet 2 date; 7 days after the Date of Send on Sheet 1? and 10 days from the send of sheet 2 on sheet 3?

I know I'm getting super complicated. Let me know if this is even possible. Thanks again

Originally Posted by Mumps1

The macro still works as before if you enter "Sent" in column H of the "Blast Queue" sheet. I'm having trouble following what you are now asking. Please be more specific using examples and referring to specific cells, ranges and sheets. Maybe the easiest way to explain what you want is to enter some data in the other sheets so that I can see the end result and post the updated file with a detailed explanation.

so the new sheet I attached, I need data to move in the following way.

From the Blast Queue Sheet Once you enter "SENT" in the H Column --> move entire row to Initial Email Blast Sheet --> I also want "Date of Send" Column E to automatically populate a date (Date of send in Column E + 7 days)

From Initial Email Blast Sheet once you enter "sent" in that H Column (in initial Blast) -->move that same entire row to Follow Up Blast Sheet ---> "Date of Send" Column E to automatically populate a date (Date of send in Column E + 7 days)

And so on that that One Row for example (Individual Listing - Fox River HTML - Pat- 10/1/2015 - AJ- OUT FOR APPROVAL) will have to move through all the sheets (Starting Point:Blast Queue, Initial Email Blast, Follow Up Blast, Follow Up 2, End Point: Completed Blasts)

Email2.xlsm