Thread: formula to send data to 2nd sheet
View Single Post
 
Old 01-19-2016, 08:44 AM
Normie Normie is offline Windows 7 32bit Office 2007
Novice
  
Join Date: Nov 2015
Posts: 14
Normie is on a distinguished road
Default 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
Attached Files
File Type: xlsx Book 2.xlsx (10.7 KB, 27 views)
Reply With Quote