Gazza83
asked on
Command button code
Please can you help, I am hoping to do away with the formulas held within E9:E917 from Sheet3 "Location.
I was hoping to use a command button that could calculate the occurrence of the listed codes (C9:C917) on sheet1 H14:H873
It would then display these in descending order.
The difficulty is that the formulas currently filter the data by the listed dates in F2:F3 sheet3 and matches this to the dates listed in B14:B873 sheet1.
help.xls
I was hoping to use a command button that could calculate the occurrence of the listed codes (C9:C917) on sheet1 H14:H873
It would then display these in descending order.
The difficulty is that the formulas currently filter the data by the listed dates in F2:F3 sheet3 and matches this to the dates listed in B14:B873 sheet1.
help.xls
ASKER
Thanks Thomas, this seems perfect! I've run the code and it took little to no processing time; whereas the old way was taken ages.
Is there a way I could sort the range highest-Lowest, maybe I could use another command button?
Is there a way I could sort the range highest-Lowest, maybe I could use another command button?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Thomas!
Glad to help. Thanks for the grade.
Thomas
Thomas
Open in new window
Thomas