So here's what I need help with, I know someone out there can help me! This is what I'm working with.
I have two worksheets, "B" and "C" that auto copy with a macros to a Master List, which is the first sheet of my workbook. The columns for these sheets match up. Column D is the Status column, with a drop down list. There are many options such as Funding, Comtract Out, Hold, Dead, and Lost. The only three I am worried about are the Hold, Dead and Lost Deals. I want to create three new sheets named respectively, so that when I choose hold, dead, or lost, they are auto-copyed into the right sheet, while being deleted from the original sheet they were on.
I have tried adapting so manu codes and i cant get any to work, can anyone help me???
Bookmarks