formula to send data to 2nd sheet

		Microsoft Office Forums > Microsoft Excel > Excel
formula to send data to 2nd sheet

FAQ

Mark Forums Read

Thread Tools

Display Modes

01-20-2016, 07:21 AM

Normie

Windows 7 32bit formula to send data to 2nd sheet

Office 2007

Novice

Join Date: Nov 2015

Posts: 14

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:49 AM.