Hello everybody! Normally I get some good responses on here so hopefully you will be able to help me again.
I have a spreadsheet, a simple sales tool.
UPC Description Department Sales last Week Sales this Week 00001 Item 1 Department 1 100 200 00002 Item 2 Department 1 200 400
and repeat with 4000 UPCs and 35 departments with just as much sales data.
Being the company we are and being a startup, I have been employed with analysing the sales data every week.
My manager has asked for a "Top 5 by Department" list so ideally I was hoping to filter by department, then run the Excel 2007 "top 10" list for each department thus giving me the data I needed. WRONG was I. I can only seem to run the top 10 for the entire store, not for each department. This is currently taking me 2 hours a week to filter by each department, then put them in number order, copy and paste the top 5 into a table and email it out. I need this scripted somehow, but I'm coming to a dead end.
I have no code to show, as I have literally got to the point of just deleting it all and starting it all over again.
So could you please help me out with this? It would be muchly appreciated.
If I have missed something simple, like putting it into a pivot table then please tell me and I will let you know.
Also, the computers are fairly slow, the less calculations Excel needs to do the better, as I remember running a script with 20,000 calculations in and it slowed us all down :-(
Kindly thanking you all in advance
Chris
One other thing; a quick one: The "Department" column is generated manually, I have a back copy of the catalogue which references the UPC from another sheet and runs a VLOOKUP to return the department code. However I would like to add a button to a userform which I can just click and it inserts a column and the required formula. That would also help me out!
Bookmarks