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 Show Data In Range not appearing in Separate Range

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
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
QUERY data range to populate separate worksheet? Greg Purnell[_2_] Excel Worksheet Functions 3 April 5th 07 01:49 PM
Charting data points and show a target range on the same chart. Minireefkeeper Charts and Charting in Excel 6 February 18th 06 06:50 PM
How do I show range of data in an area chart? slycke Charts and Charting in Excel 1 September 1st 05 01:11 PM
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE Excel Discussion (Misc queries) 1 June 24th 05 06:31 PM
HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE Excel Worksheet Functions 0 June 24th 05 05:27 PM


All times are GMT +1. The time now is 01:20 PM.

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

About Us

"It's about Microsoft Excel"