Messy report to compile
Posted by Laura L on September 06, 2000 12:02 PM
I am trying to wrap my brain on the best way to approach this problem:
I have 40 Dealerships sending me their numbers for a Used Car Report. This includes the make , model name, year of vehicle, etc.. many columns in other words. I have created a template for them to fill out this information on. I need to find the easiest way to compile a list of all the cars sold from all the dealerships and have them sorted first by Make then by Year of the vehicle. With 40 templates of information coming in, no way of knowing how many rows of information I need to compile, etc... I need to make this as easy as possible since there will be others trying to compile this report through the sheets I create that know N-O-T-H-I-N-G about Excel. Anyone have any super great ideas on how I Should tackle this?