Bindi_Baji
New Member
- Joined
- Jul 28, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
Hi all,
I'm hoping somebody could offer a suggestion for a method to calculate the total order amount of a given item within VBA.
Basically, we have numerous items which need to be worked through to figure our the total order for each item. The issue I'm having is because of the way our stock system exports the data.
Please see below example of one item:
(cant install mini sheet on work laptop unfortunately.)
Essentially, the total order for Item 10001 should be 120 + 100 + 75 + 80 + 100 + 120 + 260 = 855
I hoping to find a method of calculating this on the fly for each item in a VBA procedure but having real trouble getting my head round the calculations.
We have hundreds of different customers so unfortunately I'm not sure filtering on these would be effective.
Any help would be gratefully received
I'm hoping somebody could offer a suggestion for a method to calculate the total order amount of a given item within VBA.
Basically, we have numerous items which need to be worked through to figure our the total order for each item. The issue I'm having is because of the way our stock system exports the data.
Please see below example of one item:
(cant install mini sheet on work laptop unfortunately.)
Essentially, the total order for Item 10001 should be 120 + 100 + 75 + 80 + 100 + 120 + 260 = 855
I hoping to find a method of calculating this on the fly for each item in a VBA procedure but having real trouble getting my head round the calculations.
We have hundreds of different customers so unfortunately I'm not sure filtering on these would be effective.
Any help would be gratefully received