View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Brent E Brent E is offline
external usenet poster
 
Posts: 74
Default Filter Range on Sheet B Based on List on Sheet A

Excel 2003

Good evening Everybody,

I need assistance to generate a formula or macro

Basically what I am trying to do is to set up a filter that will list
projects on Sheet B
that aren't listed on Sheet A

I have 2 priorly constructed worksheets that I was asked to work with.

For example purposes, names are SheetA and SheetB,
spacing is inconsistent and data is non-sequential.
___________

Example Sheet A

Col A Col B
Projects Apr

BB2029
PARS 20
ABSB 90

BB3500
PARS -
Bud 300
Insp 80
PB -

BMM144
PARS 9
ANA 35

______________
Example Sheet B

Col A Col B
Projects Apr
BB2029 350
SR2000 20
BB3500 -
AS2044 200
MM2000 355
BMM144 900
RN1440 -

I need a forumula or macro
that will:
For each Project name
on Sheet B: ColA,
Search for same Project on sheet A: ColA

If the Project Name
from Sheet B is found on
Sheet A, then
On Sheet B, hide that data row.

Sheet B Output for this example:
Col A Col B
SR2000 20
AS2044 200
MM2000 355
RN1440 -

Thanks Much,