#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Success!! what I forgot to mention is that I need the data from H2 to H300
I have tried this =IF(Sheet2!$H2:H300="NO",Sheet2!A2:A300,"") but get a blank |
#4
|
||||
|
||||
All you needed to do was to copy the formula I gave you - as I gave it - paste it into B3 and copy from there to B3:H300. Why you'd think you needed to change it beats me...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
I dont have the room on Sheet one to use the 300 lines just want to pull anything that shows "NO" on Sheet 2 to show in the grey box on Sheet 1 sorry for any confusion
|
#6
|
||||
|
||||
As I said in post #2, a formula can't show/hide rows. A formula to fill 'YES' gaps would be considerably more complex and you'd never know whether all the data were captured unless you made sure to have amply more rows with formulae than you have with 'NO' data to display.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Thread Tools | |
Display Modes | |
|
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 |