vba macro code for finding the common entry names

[Dharani Suresh]

Dear Sir / Madam,
In the given excel file, From all 14 sheets the code has to check for the common "entry name" (which is in different columns like COL G, E, H, F, and so on ..) and has to give in the separate sheet.

please do the needful.

Thank you.

Regards,
Dharani.

[venkat1926]

macro is ready . given below

I have a doubt in the first sheet ww 08-09 some names in column G repetition of name though other parameters in other columns may be different now in the final sheet these duplicates remain. anyhow run the macro and tell me further explanation

DO OT CHANGE CONFIGURATION OF THE ORDER OF SHEETS. LAST SHEET IS CALLED "result"

Please Login or Register  to view this content.

macro will run for about five seconds.

see the sheet "result" and then resapond

[venkat1926]

If you want only uniuqe names in sheet "result5" then you can get unique name by invoking advanced filter.on this sheet data

[Dharani Suresh]

macro is ready . given below

I have a doubt in the first sheet ww 08-09 some names in column G repetition of name though other parameters in other columns may be different now in the final sheet these duplicates remain. anyhow run the macro and tell me further explanation

DO OT CHANGE CONFIGURATION OF THE ORDER OF SHEETS. LAST SHEET IS CALLED "result"

Please Login or Register  to view this content.

see the sheet "result" and then respond

Hello Venkat,
Thank you for the code and the effort you made for solving this. my heartfelt thanks to you... still a small modification is needed. the code is not giving the right answer. i need common entry names from all 7 sheets along with the other cols values as well. please try this and give me the code... and also i m attaching another file, please try with this file.

Looking forward for the positive reply... i hope this time i m clear with my question...
Thank you,
Regards,
Dharani.

[Dharani Suresh]

Hello Venkat!

Can you please modify the code and give me.. i need urgently... please help me...

Looking forward for your reply...

Thanks,

Regards,
Dharani.

[Dharani Suresh]

Venkat!

Thank you for the effort you made in helping me... thank you so much for spending your valuable time in helping me..

Regards,
Dharani.