Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link a list or range of cells to another sheet in same workbook | Excel Discussion (Misc queries) | |||
Advanced Filter w/ multiple sheet List Range | Excel Worksheet Functions | |||
'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
Moved data to new sheet based on list selection | Excel Worksheet Functions | |||
Lookup cell contents in on sheet based on a formula in second sheet | Excel Worksheet Functions |