View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dolphy Dolphy is offline
external usenet poster
 
Posts: 28
Default Help with cleaning up a workbook.

Hi All,

I have two documents, one is the master (A) list and the other is the
used (B) list.

I want to remove data from the used list (B). In effect it will be B -
A.

All of the data I have is numerical.

For example:

Worksheet A would have:

04121
04122
04123
04124
04125
04126
04127
04128

Worksheet B would have:

04122
04124
04125
04128

The result would be:

04121
04123
04126
04127

Is there an easy way of doing this in Excel?

Rgds,
Dolphy