Hello! (This is my first post on any sort of forum)
I'm working in a large database that has the same formatting on each sheet. I use the database to track vehicle orders from start to finish. When an order is placed it goes on one sheet, then as the order progresses I move it to the next sheet, and so on...) My sheets are: New Orders, Approved, On the Road, Returned.
What I am looking to do is have a master sheet of Customer names with out duplicates so that I can track how many orders that specific customer has had (Plus some other things involving a pivot table but we will get to that another time once I figure this out.)
To Clarify: I want to be able to list how many unique customer names I have in the entire database. Customer Steve could have 2 orders in Approved and 3 on Returned. But I only one his name to appear once on the master sheet of Customer names.
I have been trying to run a Macro that pulls ALL data from ALL my sheets, dumps it into the Master sheet, then removes duplicates, but have yet to be successful with that.
Any ideas on what the best way is to get the data I am looking for?
Bookmarks