Compare the string between two worksheets and give the result in worksheet 3

[hakuna.matata]

Hello Everybody
I want to search or compare string between two worksheets and when the comparison is found then it gives the sum of the corresponding column of the compared string in the worksheet 3. The example is attached with this post. Thanks a lot.

[patel45]

to compare see http://www.mrexcel.com/forum/showthr...ll-is-the-same

[hakuna.matata]

Thanks a lot for your reply. Actually i am newbie in vba can you also tell me that after searching the compared strings, if strings have more than one ids then it gives the sum of compared ids.

---------- Post added at 03:54 AM ---------- Previous post was at 01:36 AM ----------

Can somebody please help me in this post. It is really important and urjent.

[patel45]

try this, if you change position of ranges you have to modify some lines

Please Login or Register  to view this content.

[hakuna.matata]

Thank you really very much this will be certainly very helpful for me

[Cutter]

@ hakuna.matata

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

[hakuna.matata]

Hello Patel
Although the thread is marked as solved but i have a question from you, which is that if i want to change the column in Sheet 1 in this case i want to change the column C to F, D to P and E to S then where should i make changes and other question is that in Sheet 2 if Column C is changed to G and D is changed to K and E is changed to M then where should i make the changes.

---------- Post added at 05:04 PM ---------- Previous post was at 04:41 PM ----------

I have already solved it, no need to reply.