Hello,
I need some help developing a VBA code to move a row of cells based upon a cell which contains a dropdown list. I'm ok with the basic formulas however when it comes to VBA I'm clueless since I haven't used VBA in a very long time, so any help would be appreciated.
Basically my list is similar to Task List which lists projects, due dates & completion status, fairly basic stuff.
Currently I have my status' setup in a dropdown list as, without the double hyphen
--Completed
--Awarded
--Not Started
--In Progress
--Lost
--Not Bidding
I currently have VBA Code to move the "Lost", "Not Bidding" & "Awarded" to three similarly named Worksheets. What I am attempting to do now is break down my Project List into "Completed", "Not Started" & "In Progress" on the same worksheet versus breaking them out into different worksheets.
I've searched the web & various forums and all I can seem to locate is moving a row to another workbook or worksheet.
Thanks in advance for the help....
Scott
I need some help developing a VBA code to move a row of cells based upon a cell which contains a dropdown list. I'm ok with the basic formulas however when it comes to VBA I'm clueless since I haven't used VBA in a very long time, so any help would be appreciated.
Basically my list is similar to Task List which lists projects, due dates & completion status, fairly basic stuff.
Currently I have my status' setup in a dropdown list as, without the double hyphen
--Completed
--Awarded
--Not Started
--In Progress
--Lost
--Not Bidding
I currently have VBA Code to move the "Lost", "Not Bidding" & "Awarded" to three similarly named Worksheets. What I am attempting to do now is break down my Project List into "Completed", "Not Started" & "In Progress" on the same worksheet versus breaking them out into different worksheets.
I've searched the web & various forums and all I can seem to locate is moving a row to another workbook or worksheet.
Thanks in advance for the help....
Scott