Need to automate find/delete process

[Matt26]

hey all,

not sure if this is the correct forum for this question.

i have two spreadsheets. one contains a master list of computer names. the other contains a list of computer names to be removed from the master list (exception list).

i need to go through the master list and remove any computer names that are on the exception list- for example, if 'computer1' is in the exception list, i have to find and remove 'computer1' from the master list.

the exception list is quite long, and i want to automate this process if possible. not sure how to achieve this.

i'm using Excel 2007 Standard.

any help is greatly appreciated.

thanks!

[hemesh]

Hello and welcome to the forum Matt ! can you upload a sample book with enough data to work with.

to attach go to advance option and select paper clip icon

[Matt26]

Hello and welcome to the forum Matt ! can you upload a sample book with enough data to work with.

to attach go to advance option and select paper clip icon

i can't provide the actual lists because they contain company information.

the spreadsheets only have one column each, which list the hostnames.

i've attached a basic example.

[hemesh]

Hello Matt! Find the attached !





master_list.xlsx

[Matt26]

Hello Matt! Find the attached !




Attachment 288880

hi hemesh, thanks very much for putting this together for me, much appreciated!

forgive my ignorance here, how do i perform the find/delete process?

this uses formulas instead of macros, correct?

thanks again!