Hansen
10-27-2016, 02:27 AM
Good morning everyone,
Hope you are all doing good.
I have an excel table with order numbers in column A and dates of the order in column B. Usually this table holds between 20.000 and 40.000 different orders for a month, so with around 25 different dates.
Basically I want to know on how many days we received orders, but I only want to consider days where we received more than 10 orders (for example on only 18 days out of the 25 different days, 10 or more orders were generated. Then I want to receive the number 18).
I know how to solve this problem with a pivot table, but want to do it using a VBA macro.
Any input on how setup a micro to do this would be highly appreciated.
Thank you!
Hope you are all doing good.
I have an excel table with order numbers in column A and dates of the order in column B. Usually this table holds between 20.000 and 40.000 different orders for a month, so with around 25 different dates.
Basically I want to know on how many days we received orders, but I only want to consider days where we received more than 10 orders (for example on only 18 days out of the 25 different days, 10 or more orders were generated. Then I want to receive the number 18).
I know how to solve this problem with a pivot table, but want to do it using a VBA macro.
Any input on how setup a micro to do this would be highly appreciated.
Thank you!