We Will go in detail
1) in Sheet 1 column G:G and up to Column O:O we have Consumed Materials Qty in each group in many rows in the same column,
Corresponding to that in column P:P Material Consumption started date and in column Q:Q Consumption End Date, These data are to be collected from this sheet,
go to the another page in sheet 2 in Column B:B the same materials of sheet 1 and from Column G:G and up to Column O:O will be in transpose position.
now match The materials in Sheet 2 B:B with Sheet 1 Row-1 From Column G to Column O and find respective consumption,
the consumption falls with particular date and fill the qty
1) in Sheet 1 column G:G and up to Column O:O we have Consumed Materials Qty in each group in many rows in the same column,
Corresponding to that in column P:P Material Consumption started date and in column Q:Q Consumption End Date, These data are to be collected from this sheet,
go to the another page in sheet 2 in Column B:B the same materials of sheet 1 and from Column G:G and up to Column O:O will be in transpose position.
now match The materials in Sheet 2 B:B with Sheet 1 Row-1 From Column G to Column O and find respective consumption,
the consumption falls with particular date and fill the qty