Thread: Managing sales data from multiple users.

First time forum user, using Excel 2003 at work. I am mostly self-taught on Excel and consider myself an intermediate user. I have to report on sales data that changes daily. My data includes multiple sales people from multiple offices that can each sell several products. In looking for summaries and trends, I have date of sale, type of product, sales person, and of course their market.

Up until now I have kept a spreadsheet where all this data was housed. When it came time to report on it, I have used a combination of using a subtotal formula (=SUBTOTAL(3,range)) and data filters to manually get all my information needed on my sales report. Things like the office had this many sales of this type of product, etc. Everything I have had to report on I change the data filters, check my numbers at the bottom where my SUBTOTAL formula was and setup a report that way. All of this data is date sensitive for my reports, often comparing one week with previous week or an average.

I am sure there has to be a more efficient way to compile and/or use this data.

Is Excel what I should be using? or Access? I will appreciate any help I can get here.

Thanks,
Josh