Let me describe what I am expecting.
File can be accessed from Link
My ultimate goal is to get the answer in AN column which I have highlighted with green.
Data in AT:AY is simple the pulling the data from other sheet.
The main calculation column required is from AZ columns and to the right side.I have made for 3 months only with manual calculation in Month-1 i.e AZ:BZ column
I have show in AT Column Itemwise with their Sub Total at each.Here,I have taken of Month-1 and done calculation in AZ column whereas BA column is simply AY*AZ.
As I have multiple items with multiple month and data will accordingly shift to right side which I have started from AZ column as manual allocation is not possible in AZ column,so I do expect by vba that allocation of AM column based on month and item be by matching month AU column and item AT and the result towards column AZ & to right.
If any queries then kindly let me know.
File can be accessed from Link
My ultimate goal is to get the answer in AN column which I have highlighted with green.
Data in AT:AY is simple the pulling the data from other sheet.
The main calculation column required is from AZ columns and to the right side.I have made for 3 months only with manual calculation in Month-1 i.e AZ:BZ column
I have show in AT Column Itemwise with their Sub Total at each.Here,I have taken of Month-1 and done calculation in AZ column whereas BA column is simply AY*AZ.
As I have multiple items with multiple month and data will accordingly shift to right side which I have started from AZ column as manual allocation is not possible in AZ column,so I do expect by vba that allocation of AM column based on month and item be by matching month AU column and item AT and the result towards column AZ & to right.
If any queries then kindly let me know.