Copy row if criteria is met macroClosed

Question

Hello, 

I am looking to make a macro that will copy the entire line from sheet 1 to sheet 2 if criteria from column H is met. 

Essentially if the cell in Sheet 1 Column H says "Awardee", I'd like all the information from that row to be copied into Sheet 2.
Thanks.

Configuration: Windows 7 / Internet Explorer 10.0

fdibbins · Answer

Does this have to be VBA?  You could do this with an ARRAY formula or with a helper column.

msg back if this a direction you would be interested in?

fdibbins · Answer

Option 1			aaaaa	Head1	Head2		Head1	Head2aaaaa	1		aaaaa	1bbbbb	2		aaaaa	4ccccc	3			aaaaa	4			bbbbb	5			ccccc	6			
D3=IFERROR(INDEX(A:A,SMALL(IF($A$3:$A$8=$D$1,ROW($A$3:$A$8)),ROWS($A$1:A1))),"")
ARRAY entered, using CTRL SHIFT ENTER, not just enter
Then copy down and across as needed

Option 2 using a helper column (which you can hide if needed)
Option 2				aaaaa	Head1	Head2			Head1	Head2aaaaa	1	aaaaa 1		aaaaa	1bbbbb	2	bbbbb 1		aaaaa	4ccccc	3	ccccc 1			aaaaa	4	aaaaa 2			bbbbb	5	bbbbb 2			ccccc	6	ccccc 2			
C3=A3&" "&COUNTIFS($A$3:A3,A3)
copied down
This will create a unique ID for each duplicate that can then be used to extract it

E3=IFERROR(INDEX(A:A,MATCH($E$1&" "&ROWS($A$1:A1),$C:$C,0)),"")
regular formula, copied down and across as needed

Hope that helps?

Copy row if criteria is met macro

2 responses

Similar discussions

Subscribe To Our Newsletter!