Taking data from one table then finding and deleting in another

**lifes_cinders** · 10-02-2006, 06:26 AM

Hello,

This may be a simple macro answer but I have two tables.
One contains a user num which I must find and delete in another.
I have over 10,000 of these and do not believe I have to find and delete all individually.

Basically I'm wanting to find data from one table and deleting it from another.....
Anyone help me please?

**funkymonkUK** · 10-02-2006, 06:29 AM

is there one column with the value you are looking for that needs to be deleted?

ie

col1number - col2 value
1 - 4546
2 - 78998
1 - 5462

so what you want to do is find all the value 1 in col1 and delete it right? if so let me know there it will be quiet a simple macro which you would need to implement

**lifes_cinders** · 10-02-2006, 06:32 AM

Ok, i have 2 tables...

table 1---------------------------table 2
name.id.age----------------------name.id.age
bob.325.25-----------------------bob.325.25
fred.658.30 ---------------------- fred.658.30
-----------------------------------james.765.40

I wish to use all ID's from table 1 and find and delete in table 2

**funkymonkUK** · 10-02-2006, 06:41 AM

so in other words you would only have james.765.40 in table two right?

are both these tables in the same workbook?

**lifes_cinders** · 10-02-2006, 06:44 AM

They are not in the same work book, but i can make a separate sheet and put them in if needs be.

but yes i wish that all the users in one table be found and deleted in another table.