I am trying to find a way to take a list of agent sales and copy each agents info to a new sheet and save as a PDF. Each agent could have any number of sales listed so I need to make sure all rows with that agent’s ID number are copied. Is this possible?
Joanne