Copy Cells Which Meet "True" (not false or blank) criteria, skip blanks

[ellison]

Hi, wondering if there is a way to copy info from cells where the criteria (on the next column) is "true"...

Our info sometimes contains blanks, or numbers.

Would something like this that I've mocked up below be possible?

Copy-where-criteria-is-true-skip-blank-01-question.xlsx
	A	B	C	D	E	F
1	Row	Info	Criteria			Info
2	2	alpha	TRUE			alpha
3	3	beta	FALSE			9
4	4					golf
5	5	9	TRUE
6	6	echo
7	7	foxtrot
8	8	golf	TRUE
9	9
10	10	hotel	FALSE
Sheet1

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F
1	Row	Info	Criteria			Info
2	2	alpha	TRUE			alpha
3	3	beta	FALSE			9
4	4					golf
5	5	9	TRUE
6	6	echo
7	7	foxtrot
8	8	golf	TRUE
9	9
10	10	hotel	FALSE
Sheet4

Cell Formulas
Range	Formula
F2:F4	F2	=FILTER(B2:B100,C2:C100)
Dynamic array formulas.

 

[ellison]

Absolutely brilliant - HUGE thanks!

 

[Fluff]

You're welcome & thanks for the feedback.