|
|
#2
01-19-2016, 08:28 PM
|
||||
|
||||
You could use a formula like:
=IF(Sheet2!$H2="NO",Sheet2!A2,"") in B3 and copied to B3:H9 to conditionally show/hide the data, but a formula can't show/hide rows.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Can a Data Source be one sheet in a multi-sheet Workbook
|
nfotx | Mail Merge | 1 | 07-01-2015 12:55 AM |
| Move data from one sheet to the next available row or cell of another sheet | bwwalker08 | Excel | 0 | 04-10-2015 11:51 AM |
| Populate sheet 3 with data from sheet 1 and sheet 2 | speck | Excel Programming | 0 | 01-14-2015 07:54 AM |
|
Help Coloring a cell in Sheet one if data is missing from another sheet
|
Aeducan | Excel | 1 | 06-22-2014 04:49 PM |
| sheet 2 data highlight in sheet 1 | gsrikanth | Excel | 1 | 04-21-2012 06:25 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode