Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Excel 2003
Good morning Everybody, I need assistance to generate a formula or macro based on example data below I have 2 priorly constructed worksheets that I was asked to work with. For simplicity and example purposes, names are SheetA and SheetB, spacing is inconsistent and data is non-sequential. ___________ Example Sheet A Col A Projects BB2029 PARS ABSB BB3500 PARS Insp BMM144 PARS ANA ______________ 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: Compare Project names in Sheet A to Project names on sheet B: If the Project Name on Sheet B is found on Sheet A, then On Sheet B hide the data row End result on Sheet B is a list of project names and data for all projects not listed on Sheet A. 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 | |
|
|
![]() |
||||
Thread | Forum | |||
QUERY data range to populate separate worksheet? | Excel Worksheet Functions | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
How do I show range of data in an area chart? | Charts and Charting in Excel | |||
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Discussion (Misc queries) | |||
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE | Excel Worksheet Functions |