Delete row and Move to another sheet based on dropdown list

[adsako]

Hello VBA experts

I'm looking for some help
I'm absolutely not familiar with VBA and I would need your support over there

I have excel workbook with 3 worksheets (contract review tracker, completed Contracts, drop down list) where in column T in Contract Review Tracker there is a drop down list
as soon as status in Contract Review Tracker is marked as "completed" I would like to delete this row/line and move all the information from this worksheet to worksheet Completed Contracts

can you please support ....

NOTE: I looked at some "old" posts and solutions provided however I cannot find any that would be applicable to my case
this being said your inputs and possible solutions are highly appreciated

I have tried to run macro from the post I found
https://www.excelforum.com/excel-pro...ease-help.html
however it is not working ...

can you please advise and help me to sort this topic ;(


thank you
Adam

[dangelor]

Possibly...

Please Login or Register  to view this content.

FYI there is a space at the end of the tab named "Completed Contracts " that probably shouldn't be there.

[adsako]

Hello

@dangelor ... thank you for this
it helped a lot

Adam