Microsoft Office Forums - View Single Post - formula to send data to 2nd sheet

Thread: formula to send data to 2nd sheet

View Single Post

Old

01-20-2016, 07:21 AM

Normie

Normie is offline

Normie uses Windows 7 32bit

Windows 7 32bit Normie uses Office 2007

Normie uses Office 2007

Office 2007

Novice

The original poster

Join Date: Nov 2015

Posts: 14

Normie is on a distinguished road

Default

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

Reply With Quote