New to VBA Need help on moving rows back and forth between sheets based on cell Value

You could try this in the ThisWorkbook class module. You'll have to comment or delete the code in the worksheet module

Please Login or Register  to view this content.

I'll leave you to test and figure if it's suitable/how it works but it depends on the actual sheet name being entered in Col I - it might be an idea to convert everything to ListObjects (Tables) and add Data Validation for the allowable choices - it'll still move if a worksheet is found but any other values will be ignored.

You certainly seem to be making life complicated for yourself. Why not leave everything where it is, maybe convert the data to a Structured Table, and then use Filter and/or Sort to list the data, and use Pivot Tables and Slicers to analyse the data.

No VBA required. No likelihood of data going missing or getting corrupted in transit.

It goes in the ThisWorkbook class module.

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.