SabrinaVBA
New Member
- Joined
- Feb 10, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
I have been having some issues with this. I have data set up like the image below. I need a VBA to copy the whole row and place it in the correct tab.
So for below I need row 2 to be copied to the "Yes" tab, row 3 to the "No" tab and row 4 to be copied to the "Maybe Tab.
The data will also grow and change.
New data will be added on rows 5-??
And the data validation in column D can change. So once row 4 changes from maybe to yes I would need that row to be removed from the "Maybe" tab and copied to the last row in the "yes" tab.
Can this be done in VBA?
I am a newbie and have limited skills, I have found a few codes that almost worked, the closest one would copy the information once information in column D changed but it kept copying ALL the data so it would repeat row 2 over and over and over.
So for below I need row 2 to be copied to the "Yes" tab, row 3 to the "No" tab and row 4 to be copied to the "Maybe Tab.
The data will also grow and change.
New data will be added on rows 5-??
And the data validation in column D can change. So once row 4 changes from maybe to yes I would need that row to be removed from the "Maybe" tab and copied to the last row in the "yes" tab.
Can this be done in VBA?
I am a newbie and have limited skills, I have found a few codes that almost worked, the closest one would copy the information once information in column D changed but it kept copying ALL the data so it would repeat row 2 over and over and over.