Please help for Dup Removal and some data processing

Hello Dear Experts,

Please check the attached file. I have searched a lot of information on web and have really not been able to make a macro that does the following things:

1> Remove duplicate rows based on column A from "Main" sheet.
2> Insert data in columns C, D and E of "Main" sheet from other three sheets, based on ID.

I have used For Loop but it does not work for unknown number of rows.


Pleease Help

Thank you all

Also Posted here:
http://www.mrexcel.com/forum/excel-q...ml#post3577195
http://www.vbaexpress.com/forum/show...225#post297225
http://www.ozgrid.com/forum/showthre...276#post684276