Need VB code and macro on match cell and add volume

[SANDYSMELMAT]

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

[PCI]

Have you had a look on Pivot Table ???
Can you prepare a short Excel sample with dummy data to illustrate your data lay out and final result you want

[dflak]

I agree with PCI, both on attaching a workbook and possibly using a pivot table. Your data may have to be manipulated into a format that a pivot table can use.

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.