CalumJames
New Member
- Joined
- Jun 18, 2011
- Messages
- 13
Hi all
Ok, so I've been doing quite a bit of work on a workbook for a project, though i need some assistance with the last part.
There are different tabs for each stage of the project:
Minor
Major
Other sites
Completed Minor
Complete Major
Completed Other Sites
Monitoring
So if the project is a small one, it goes into Minor, and if it's major it goes into the major one, if it's offsite it goes into other sites (these are any size other site projects whilst "in progress" so to speak) - all manually - this is fine... however I have a column called status on all tabs, column K . Within this column is a dropdown, which lists each tab name. Basically what I need to a target VBA to move the entire row from the current sheet to the selected dropdown named tab under any current rows - so the next available row on the chosen tab.. this may not be the same row number as the chosen row.
And then I need it to move the remaining rows below it up one (to remove the space left by the moved row).
I would attach the sheet so it's easier to understand but seems I'm not allowed.
appreciate any help or advice.
Ok, so I've been doing quite a bit of work on a workbook for a project, though i need some assistance with the last part.
There are different tabs for each stage of the project:
Minor
Major
Other sites
Completed Minor
Complete Major
Completed Other Sites
Monitoring
So if the project is a small one, it goes into Minor, and if it's major it goes into the major one, if it's offsite it goes into other sites (these are any size other site projects whilst "in progress" so to speak) - all manually - this is fine... however I have a column called status on all tabs, column K . Within this column is a dropdown, which lists each tab name. Basically what I need to a target VBA to move the entire row from the current sheet to the selected dropdown named tab under any current rows - so the next available row on the chosen tab.. this may not be the same row number as the chosen row.
And then I need it to move the remaining rows below it up one (to remove the space left by the moved row).
I would attach the sheet so it's easier to understand but seems I'm not allowed.
appreciate any help or advice.