Matching values from a sheets and mapping it into Summay sheet

Hi,

I need help in creating a summary sheet which will list total of all my items category wise.By manually mapping the value takes lot of time to prepare the summary sheet.

The Macro should be able to search the category total from sheet2 and sheet3 and insert the total value in summary sheet. I have attached a sample sheet which can clearly explain the scenario.

Thanks for your help in advance.

Try

Please Login or Register  to view this content.

Thanks Jindon for your quick help.