- Dec 16, 2009
I have a page in excel that has sales information for multiple company's and they may reoccur several times on the page depending on how many times they purchase from us per month. each sale starts with the company's name and a 4 digit number to identify them and all the sales information is in the column below. I am looking for a way to have a second page that will automatically copy and gather all the sales information based on the company's code regardless of how many times the company shows up. Basically I am trying to collect and sum up the total sales, but i don't know where the sales are going to be recorded. Can any body figure this out?