Find a String and add up corresponding numeric valuse accross different worksheets.

[Nizamuddin]

Hi,

I have a workbook with hundreds of worksheets, with data in the first 5 coloumns the first 3 coloumns have string with ID, Name, and Description and the rest 2 coloumns have integer numbers.
I would like to have a summary sheet with the list of few Names for which I need to find the total sum of corresponding values in every sheet present in the workbook.
I want to pick up the first name in the summary sheet find it in Col 2 and when found add up the total of col 4 next to the name in the summary sheet. and similarly the sum of col 5 in the next cell of the summary sheet and loop thru all the worksheets present, similarly continue doing for the next name until a blank cell is reached.
The number of sheets in the workbook may vary and so can the items to be searched for... hence all of this needs to be dynamic.

Any help with a code that can do this task would be greatly appreciated !

Thanks in advance.

 

[Nizamuddin]

That worked...!!!

Thanks a ton!