Hello all ,
I am looking for help from experts here , I need to develop macro so that it can be used for any commodity volume comaprision,
I have report coming in every month , it has more than 30 column , part number, forecast volume and actual volumes are one I am interested.
Lets say Part number "A" has been used at different plants , each plant having its own forecast volume and actual volume,
I need to know total forecast volume and total actual volume of Part A, and would like to take difference between them.
I mean Lets say there are 500 rows in excel sheet with 20 unique part numbers , I want macro which can consolidate volume of all 20 PART NUMBER
and take difference between forecast and actual volume.
every month number of row and new part number may be added Hence I can not constraint for specific part number
please help
Regards,
SANDEEP
Bookmarks