Hi,
I'm trying to calculate the weighted average with some criteria (period, store and product) of the Data file and for each average of each product of each store in a certain period, I wanted to paste it into another Workbook (Report) in the worksheets of the respective products.
The problem is that the code I am writing, is not calculating based on these criteria (returns 0.00), if someone can tell me where I am wrong (I am a beginner in VBA), I am grateful.
Detail, I do this via formula, the problem is that they are large files (600,000 lines) and have been too time consuming.
Follow the files for better understanding.
Sorry, I do not speak English, and I'm using google translator.
Thank you for your attention.
I'm trying to calculate the weighted average with some criteria (period, store and product) of the Data file and for each average of each product of each store in a certain period, I wanted to paste it into another Workbook (Report) in the worksheets of the respective products.
The problem is that the code I am writing, is not calculating based on these criteria (returns 0.00), if someone can tell me where I am wrong (I am a beginner in VBA), I am grateful.
Detail, I do this via formula, the problem is that they are large files (600,000 lines) and have been too time consuming.
Follow the files for better understanding.
Sorry, I do not speak English, and I'm using google translator.
Thank you for your attention.