Thread: Extract data from two worksheets into one
View Single Post
 
Old 10-16-2018, 12:44 PM
Logit Logit is offline Windows 10 Office 2007
Expert
  
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default
.
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","")
Reply With Quote