Cut/Paste data from one sheet to another based on cell context

I am currently trying to enhance a “tracker” I created for my team to use to keep track of their work.

What I would like to do is cut data from one worksheet and paste it to another based on the context of a cell dropdown. On the sheet I have cut/pasted the data to, I would like there to be an option to restore the same info to the original sheet. I have tried creating a new macro, copying the macros from past worksheets and recording a new macro but in the end, nothing is working for me.


For example, on the "PENDING" worksheet, if the word "Closed" is selected from the drop down list in Column V, then the macro would select that entire row, copy the entire row, delete the entire row, then pasta the entire row to the "CLOSED" sheet. One the "CLOSED" sheet, the drop down list in the same column, Column V, would say "Restore" and if selected, then the macro would copy the entire row, delete the entire row, then pasta the entire row to the "PENDING" sheet.

Can one of you wonderful, incredibly smart, people PLEASE help me. I have spent so much time trying to get this to work and I only have failed attempts to show for it.


THANK YOU!!!!

I don't fall into the category of "wonderful, incredibly smart people".
Now, if you would have said "incredibly good looking people", that would have been another story.
I know you're going to say "No conceit in your family, you've got it all!"
OK, all kidding aside

Code for the macro button on "Pending" sheet

Please Login or Register  to view this content.

Same code for the "CLOSED" sheet except

Please Login or Register  to view this content.

Hello Hankslady,

Another option would be to use a Worksheet_Change event code which would not require any buttons:-

Place this code into the "Pending" worksheet module:-

Please Login or Register  to view this content.

and this into the "Closed" worksheet module:-

Please Login or Register  to view this content.

Thus, as soon as you make a selection from the drop downs, the relevant row of data will be immediately transferred to the relevant work sheet.

@Jolivanes:-

I just want some attention too

I hope that this helps.

Cheerio,
vcoolio.

Hi vcoolio
I initially had the same as your suggestion but I thought there could be a possibility of the dat extending past the column in question.
However, I do think it is the better solution. If there is data past that column, they can always change the V column to a column at the very end.
By the way, with your good looks, attention comes automatically!!!!!

By the way, with your good looks, attention comes automatically!!!!!

Ya really think!

Best wishes!

Attachment 755981

I can't comment as I get an "Invalid Attachment" error.

Cheerio,
vcoolio.

See attached.