jstephens01
12-10-2008, 07:23 PM
Using Excel 2003, I need to do the following:
So essentially I have the status column with a drop down that contains, Construction Complete, Ready For Install, and Complete. What I want to happen is when the status is changed to:
Complete: The whole row will transfer/copy to the corresponding tabbed sheet based on Division which is a cell within the column.
Construction Complete: The whole row will transfer/copy to the Construction Complete tab.
Ready for Install: The whole row will transfer/copy to the Ready For Install tab.
As a further note, I need this functionality on all tabs for the status.
Any help would be greatly appreciated.
So essentially I have the status column with a drop down that contains, Construction Complete, Ready For Install, and Complete. What I want to happen is when the status is changed to:
Complete: The whole row will transfer/copy to the corresponding tabbed sheet based on Division which is a cell within the column.
Construction Complete: The whole row will transfer/copy to the Construction Complete tab.
Ready for Install: The whole row will transfer/copy to the Ready For Install tab.
As a further note, I need this functionality on all tabs for the status.
Any help would be greatly appreciated.