LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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,
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to link a list or range of cells to another sheet in same workbook eholz1 Excel Discussion (Misc queries) 0 November 27th 06 11:34 PM
Advanced Filter w/ multiple sheet List Range stickandrock Excel Worksheet Functions 0 April 18th 06 02:18 PM
'Copy to' Advance Filter depend only on sheet ID not start sheet Sandy Yates Excel Worksheet Functions 0 April 4th 06 03:48 AM
Moved data to new sheet based on list selection scronk Excel Worksheet Functions 1 October 18th 05 08:08 AM
Lookup cell contents in on sheet based on a formula in second sheet Michael Wright via OfficeKB.com Excel Worksheet Functions 1 April 30th 05 04:11 PM


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"