software

I have two worksheets

Worksheet A
27 Columns
1600 Rows.

Worksheet B
1 Column
200 Rows

I need Worksheet A to look at each cell in Worksheet B, if a cell exists in
Worksheet A, then I need the row deleted...

Basically I have a list of Grand list of items to do, then a list of items
already completed. I need to now remove all entries in the grand list that
have been completed.

Is this feasible or should I look at using some Unix script.

It sounds like you could use VLOOKUP to find out if the value in B exists on
A:
www.officearticles.com/excel/...soft_excel.htm
Then use a macro like this one on worksheet A:
vbaexpress.com/kb/getarticle.php?kb_id=260

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

quot;msbutton27quot; gt; wrote in message
...
gt;I have two worksheets
gt;
gt; Worksheet A
gt; 27 Columns
gt; 1600 Rows.
gt;
gt; Worksheet B
gt; 1 Column
gt; 200 Rows
gt;
gt; I need Worksheet A to look at each cell in Worksheet B, if a cell exists
gt; in
gt; Worksheet A, then I need the row deleted...
gt;
gt; Basically I have a list of Grand list of items to do, then a list of items
gt; already completed. I need to now remove all entries in the grand list that
gt; have been completed.
gt;
gt; Is this feasible or should I look at using some Unix script.