|
|
#1
01-19-2016, 08:44 AM
|
|||
|
|||
formula to send data to 2nd sheet
I have an excel file with two sheets Sheet 1 is a dashboard for information Sheet 2 is and data entry page what I want to be able to do is when the data in column H shows NO I want to be able to see A:G of that line on Sheet 1 (grey area on attachment) I have tried an "IF" statement to no success can someone help with the formula Thank you in advance
|
|
|
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 32bit 
Office 2007
Threaded Mode