Copy/paste cells only if the value of the copied cell doesn't appear in another cell.

[jerry1992]

Hello I am trying to copy cells A3-34(sheet3) except where the value of the cell is equal to the value
of any cells in P2-100(sheet1) then paste those values into H2-33(sheet3)

Then If possible I would also like to delete any cell outside of a range specified by a value in H1(sheet3)

So if the value in H1(sheet3) is 8, then any value outside of H2-9(sheet3) but within H2-33(sheet3), would be deleted.

Is this possible?

 

[maabadi]

Change $C$3:$C$34 to Sheet1!$P$3:$P$34 at Formula
Try this:

Book1
	A	B	C	D	E	F	G
1
2	Column A		Column P			Column H
3	20		45
4	25		41
5	16		6			16
6	14		25			14
7	17		42			17
8	20		2
9	18		20			18
10	31		12			31
11	24		43
12	8		26			8
13	37		13			37
14	21		15			21
15	18		46			18
16	16		28			16
17	31		2			31
18	40		25
19	35		34			35
20	25		32
21	24		30
22	23		47			23
23	33		12			33
24	32		22
25	21		26			21
26	22		40
27	1		42			1
28	24		3
29	18		32			18
30	23		9			23
31	18		6			18
32	25		24
33	15		48
34	7		41			7
35
Sheet3

Cell Formulas
Range	Formula
F3:F34	F3	=IF(COUNTIFS($C$3:$C$34,A3)=0,A3,"")

 

[jerry1992]

Change $C$3:$C$34 to Sheet1!$P$3:$P$34 at Formula
Try this:

Book1
	A	B	C	D	E	F	G
1
2	Column A		Column P			Column H
3	20		45
4	25		41
5	16		6			16
6	14		25			14
7	17		42			17
8	20		2
9	18		20			18
10	31		12			31
11	24		43
12	8		26			8
13	37		13			37
14	21		15			21
15	18		46			18
16	16		28			16
17	31		2			31
18	40		25
19	35		34			35
20	25		32
21	24		30
22	23		47			23
23	33		12			33
24	32		22
25	21		26			21
26	22		40
27	1		42			1
28	24		3
29	18		32			18
30	23		9			23
31	18		6			18
32	25		24
33	15		48
34	7		41			7
35
Sheet3

Cell Formulas
Range	Formula
F3:F34	F3	=IF(COUNTIFS($C$3:$C$34,A3)=0,A3,"")

Thank you!

 

[maabadi]

You're Welcome & Thanks for follow-up.