Extract data from two worksheets into one

		Microsoft Office Forums > Microsoft Excel > Excel
Extract data from two worksheets into one

FAQ

Thread Tools

Display Modes

10-16-2018, 12:44 PM

Logit

Windows 10 Extract data from two worksheets into one

Office 2007

Expert

Join Date: Jan 2017

Posts: 591

.
Here is one method :

In Sheet 3, A1, paste formula : =IF(Sheet1!A2>=6,"a","")
In Sheet 3, B1, paste formula : =IF(Sheet1!B2>=6,"b","")
In Sheet 3, C1, paste formula : =IF(Sheet1!C2>=6,"c","")
In Sheet 3, D1, paste formula : =IF(Sheet2!D2>=6,"d","")
In Sheet 3, E1, paste formula : =IF(Sheet2!E2>=6,"a","")
In Sheet 3, F1, paste formula : =IF(Sheet2!F2>=6,"a","")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing between 2 worksheets and retreiving data if a match	FUGMAN	Excel Programming	8	02-18-2017 09:47 AM
Cross reference data from 2 different worksheets	connell.richard@gmail.com	Excel	0	12-06-2016 04:26 AM
Copy data btw worksheets using public arrays	OldColdDreamer	Excel Programming	4	02-10-2016 09:56 AM
How to Extract key data from word	iliauk	Word	3	11-08-2013 04:37 PM
Finding sub-sets of data in worksheets	Rudi	Excel	3	01-28-2013 06:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:32 PM.