Please help for Dup Removal and some data processing

[caabdul]

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

[caabdul]

Sorry I missed the file

[Roger Govier]

Hi

You don't need any VBA to achieve this.
First Insert Tables on each of your your sheets as I have done.
Then in cells C2, D2 and E2 of sheet Main insert the following formulae and copy down

Please Login or Register  to view this content.

This will inert the data for you.
Where the ID does not exist in any of the Tables as a Member_Num you will get a #N/A result
If you want to avoid this, then wrap each of the formula inside an IFERROR() function

Please Login or Register  to view this content.

Then to Remove Duplicates, use the inbuilt function in Excel.
Select the whole of your data on sheet Main >Data tab>Remove Duplicates> Select just ID> click OK

I have shown a graphic on the attached workbook which shows this.

[caabdul]

Dear Roger

Thank you very much for the answer. Actually I want to make a macro. Otherwise I have done this before. Thank you

[Fotis1991]

Hi there.

Pls

Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.

[cytop]

Also: http://www.ozgrid.com/forum/showthread.php?t=182683

[caabdul]

Got it, I shall care in future

[Fotis1991]

Also you must take care for this and don't do it in the future...

Your post does not comply with Rule 8 of our Forum RULES. Do not crosspost your question on multiple forums without including links here to the other threads on other forums.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).