this is a spreadsheet that I made to track sales leads. and assign them to different CSRs. I was able to get a code that will separate each row of information to a separate sheet when I click the run button. It works almost perfectly.
Unfortunately, when I click run, I get 3 new sheets named for the CSR; Caleigh and Bob work perfectly, but Jenny has leads for multiple CSRs, and the original Lead sheet, (which is meant to be the master list that always contains everything) is no longer complete.
My intent is to update this list daily with both new leads and new information (such as action taken.) I would like all entries to be on the main lead sheet and updated to the other sheets when I click run each time. I would create a new blank workbook for each month.
I have very little experience with VBA and would totally appreciate any help that I can get!
Unfortunately, when I click run, I get 3 new sheets named for the CSR; Caleigh and Bob work perfectly, but Jenny has leads for multiple CSRs, and the original Lead sheet, (which is meant to be the master list that always contains everything) is no longer complete.
My intent is to update this list daily with both new leads and new information (such as action taken.) I would like all entries to be on the main lead sheet and updated to the other sheets when I click run each time. I would create a new blank workbook for each month.
I have very little experience with VBA and would totally appreciate any help that I can get!