I thought I could do this with normal formulas but I'm having a hard time getting it to consistently perform the way I need it to.
I have a workbook that contains a few sheets.
The primary sheet is the "Master Sheet."
When I put a row into the Master Sheet I would like for it to automatically to go into certain sheets. If Column "B" contains "New" I would like for it to be copied to the sheet titled "New" and the same for "Used".
I would also like for that same row to be copied into a specific sheet depending on what is entered into Column "E." Column E will be the names of salespeople and they will each have their own specific sheets.
So every row would ideally be copied into at least two different sheets.
The complicated part that could be worked around on my end is when I might have to enter two different names in Column E.
I've attached a working sample sheet.
I would greatly appreciate any feedback.