Unique text to be appended at specified worksheet after looking into different sheet

[paradise]

Hi,

I have three worksheets namely i,a,t.The worksheet i has a data in column A,B and D which has duplicates too.Similarly worksheet a and t has a unique data in D,E,G columns.

Now what I am want is that unique data should be there in worksheet 'a'.If any data from worksheet i and t is not present in worksheet 'a' then those unique data should be appended at the end of the row in column D,E and G.Currently last row where data is 523.After row 523 should be present.Pls note that 523 filled up data is a sample one,it might be more or less than this.

I am expecting macro that just do the work.

Pls note that this post I have posted in another forum but could not get reply.Hence, have posted here.

With Best Rgds,

 

[Nebu]

Hi:

This can be done through macro, But since the volume of data is more and tab "a" has to be compared with both tabs "i" &"t", the macro is going to take lot of time. I would recommend you use access for this.

Step 1:
Link all the tab to an Access data base and make a master table out of all these 3 tabs. This master table will be having data from all the 3 tabs hence will be having duplicates.

Step 2:
Right click on the master table created and select option Copy-Copy structure only, it will ask you to give a new name for the copied table give a name of your preference. Right click only the copied table(which will be empty) and go into design mode assign primary key to your "Item" column.

Step 3:
Create an append query and append the Master table to the the table where you assigned the primary key. Once the query is run you will get data from all the three tabs without any duplicate.

This is a fairy easy exercise.

Thanks

 

[jindon]

x-post

http://www.excelforum.com/excel-pro...sheet-after-looking-into-different-sheet.html

 

[paradise]

This has been solved.Thanx to all of u.

Kindly mark this thread as solved.As I could not find for marking it solved.

With Best Rgds,