Excel "Filter" question

[bcselect]

I have a sheet(sheet 1) with four columns. i need to filter out the entries on columns c & d based on an entry in cell A22 ("M") and copy and paste those results to
Sheet 2 cell BA3. This has to be done from row 22 thru row 221.
In other words, in Sheet1 if there is an "M" in "A22" , copy and paste "C22 and D22" to Sheet 2 "BA3"

 

[AhoyNC]

Try something like this:
Change ranges to match your data.

Book1
	A	B	C	D	E	F	G
1	M	test1	item1	Prod1		item1	Prod1
2	h	test2	item2	Prod2		item4	Prod4
3	k	test3	item3	Prod3		item5	Prod5
4	M	test4	item4	Prod4
5	M	test5	item5	Prod5
6	k	test6	item6	Prod6
Sheet1

Cell Formulas
Range	Formula
F1:G3	F1	=FILTER(C1:D6,A1:A6="M","No data")
Dynamic array formulas.