Delete the Entire Row if following conditions are TRUE in Excel VBA

[An Quala]

Hi, I need to delete the entire rows in 3 sheets based on the following criteria:

If
In Sheets. 'Sponsored Products Campaigns'
>If Column B does NOT have "Keyword" or "Product Targeting" OR
>If Column S does NOT have "enabled" OR
>If Column AS does NOT have "enabled" OR
>If Column AT does NOT have "enabled"

In Sheets. 'Sponsored Brands Campaigns'
>If Column B does NOT have "Keyword" or "Product Targeting" OR
>If Column Q does NOT have "enabled" OR
>If Column R does NOT have "running" or "other"
>If Column AY does NOT have "enabled"

In Sheets. 'Sponsored Display Campaigns'
>If Column B does NOT have "Audience Targeting" or "Product Targeting" OR
>If Column M does NOT have "enabled" OR
>If Column AL does NOT have "enabled" OR
>If Column AM does NOT have "enabled"

Then Delete the entire row.

NOTE: These all OPERATIONS are ORED means if any single criteria is met, I need to delete that entire row.

NOTE2: Please don't merge/combine code for all 3 sheets, as I will place these codes in a bigger code on different places, and depending on a condition, one will run and others won't.

NOTE3: Kindly use as minimum variables as possible as they mess up the bigger code.

NOTE4: I can't attach the full file as they has all 3 sheets, but for now I am attaching all separately in code format.

NOTE5: I know there are multiple method to achieve the same result, please consider the most efficient way to do that considering rows from 5k - 100k

Sponsored Products Campaigns

Dummy Bulk Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV
1	Product	Entity	Operation					Campaign Id	Ad Group Id	Portfolio Id	Ad Id (Read only)	Keyword Id (Read only)	Product Targeting Id (Read only)	Campaign Name	Ad Group Name	Start Date	End Date	Targeting Type	State	Daily Budget	SKU	ASIN	Ad Group Default Bid	Bid		Keyword Text	Match Type	Bidding Strategy	Placement	Percentage	Product Targeting Expression	Impressions	Clicks	Click-through Rate	Spend	Sales	Orders	Units	Conversion Rate	Acos	CPC	ROAS	Campaign Name (Informational only)	Ad Group Name (Informational only)	Campaign State (Informational only)	Ad Group State (Informational only)	Ad Group Default Bid (Informational only)	Resolved Product Targeting Expression (Informational only)
2	Sponsored Products	Campaign						51810182230962		Portfolio1				Campaign Name - Dummy		20220131		MANUAL	enabled	100.0								Dynamic bids - down only				2739	10	0.37%	5.0	0.0	0	0	0.0	0.0%	0.5	0.0	Campaign Name - Dummy		enabled
3	Sponsored Products	Bidding Adjustment						51810182230962																				Dynamic bids - down only	placementProductPage	0.0		2484	2	0.08%	0.9	0.0	0	0	0.0	0.0%	0.45	0.0	Campaign Name - Dummy		enabled
4	Sponsored Products	Bidding Adjustment						51810182230962																				Dynamic bids - down only	placementTop	0.0		116	8	6.9%	4.1	0.0	0	0	0.0	0.0%	0.51	0.0	Campaign Name - Dummy		enabled
5	Sponsored Products	Ad Group						51810182230962	103843358501771						Ad Group Name - Dummy				enabled				0.4									2739	10	0.37%	5.0	0.0	0	0	0.0	0.0%	0.5	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
6	Sponsored Products	Product Ad						51810182230962	103843358501771		187095918266508								enabled		SKU Name - Dummy											2739	10	0.37%	5.0	0.0	0	0	0.0	0.0%	0.5	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
7	Sponsored Products	Keyword						51810182230962	103843358501771			133091597391670							enabled					0.58		Keyword - Dummy	broad					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
8	Sponsored Products	Keyword						51810182230962	103843358501771			20484689160127							enabled					0.64		Keyword - Dummy	broad					2085	10	0.48%	5.0	0.0	0	0	0.0	0.0%	0.5	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
9	Sponsored Products	Keyword						51810182230962	103843358501771			147161619594891							enabled					0.58		Keyword - Dummy	broad					23	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
10	Sponsored Products	Keyword						51810182230962	103843358501771			117074780596747							enabled					0.62		Keyword - Dummy	broad					394	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
11	Sponsored Products	Keyword						51810182230962	103843358501771			198054310782002							enabled					0.64		Keyword - Dummy	broad					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
12	Sponsored Products	Negative Product Targeting						51810182230962	103843358501771			216796694767871							enabled					0.64		Keyword - Dummy	broad					231	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
13	Sponsored Products	Product Targeting						51810182230962	103843358501771			116800394856451							enabled					0.64		Keyword - Dummy	broad					6	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.4
14	Sponsored Products	Campaign						224654867824700		Portfolio1				Campaign Name - Dummy		20220101		MANUAL	enabled	100.0								Dynamic bids - down only				48	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
15	Sponsored Products	Bidding Adjustment						224654867824700																				Dynamic bids - down only	placementProductPage	0.0		39	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
16	Sponsored Products	Bidding Adjustment						224654867824700																				Dynamic bids - down only	placementTop	0.0		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
17	Sponsored Products	Ad Group						224654867824700	186267109368336						Ad Group Name - Dummy				enabled				1.1									48	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
18	Sponsored Products	Product Ad						224654867824700	186267109368336		52184089599015								enabled		SKU Name - Dummy											48	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
19	Sponsored Products	Keyword						224654867824700	186267109368336			83911309498353							enabled					1.08		Keyword - Dummy	exact					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
20	Sponsored Products	Keyword						224654867824700	186267109368336			53354652434783							enabled					1.08		Keyword - Dummy	exact					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
21	Sponsored Products	Keyword						224654867824700	186267109368336			2712747284010							enabled					0.97		Keyword - Dummy	exact					34	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
22	Sponsored Products	Keyword						224654867824700	186267109368336			8880509831632							enabled					0.97		Keyword - Dummy	exact					2	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
23	Sponsored Products	Keyword						224654867824700	186267109368336			29871655919998							enabled					1.08		Keyword - Dummy	exact					1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
24	Sponsored Products	Keyword						224654867824700	186267109368336			207922361834615							enabled					1.57		Keyword - Dummy	exact					10	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
25	Sponsored Products	Keyword						224654867824700	186267109368336			82552476516641							enabled					0.8		Keyword - Dummy	exact					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
26	Sponsored Products	Keyword						224654867824700	186267109368336			125041523559069							enabled					1.08		Keyword - Dummy	exact					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
27	Sponsored Products	Keyword						224654867824700	186267109368336			178224892278959							enabled					1.17		Keyword - Dummy	exact					0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
28	Sponsored Products	Keyword						224654867824700	186267109368336			237702370532591							enabled					1.25		Keyword - Dummy	exact					1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.1
29	Sponsored Products	Campaign						60228050322464		Portfolio2				Campaign Name - Dummy		20211221		MANUAL	enabled	100.0								Dynamic bids - down only				1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
30	Sponsored Products	Bidding Adjustment						60228050322464																				Dynamic bids - down only	placementProductPage	0.0		1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
31	Sponsored Products	Bidding Adjustment						60228050322464																				Dynamic bids - down only	placementTop	0.0		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
32	Sponsored Products	Ad Group						60228050322464	225369445700841						Ad Group Name - Dummy				enabled				0.06									1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
33	Sponsored Products	Product Ad						60228050322464	225369445700841		101252162650765								enabled		SKU Name - Dummy											1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
34	Sponsored Products	Keyword						60228050322464	225369445700841			232179385161330							enabled					0.11		Keyword - Dummy	phrase					1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.06
Sponsored Products Campaigns

 

[An Quala]

Other 2 sheets

Sponsored Brands Campaigns

Dummy Bulk Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA
1	Product	Entity	Operation					Campaign Id	Draft Campaign Id	Portfolio Id	Ad Group Id (Read only)	Keyword Id (Read only)	Product Targeting Id (Read only)	Campaign Name	Start Date	End Date	State	Campaign Serving Status (Informational only)	Budget Type	Budget	Bid Optimization	Bid Multiplier	Bid		Keyword Text	Match Type	Product Targeting Expression	Ad Format	Landing Page URL	Landing Page Asins	Brand Entity Id	Brand Name	Brand Logo Asset Id	Brand Logo URL	Creative Headline	Creative ASINs	Video Media Ids	Creative Type	Impressions	Clicks	Click-through Rate	Spend	Sales	Orders	Units	Conversion Rate	Acos	CPC	ROAS	Campaign Name (Informational only)	Campaign State (Informational only)	Resolved Product Targeting Expression (Informational only)	Landing Page Type (Informational only)
2	Sponsored Brands	Campaign						144339458603378004						Campaign Name - Dummy	20210130		enabled	running	daily	1000.0	Manual	-30.0%						productCollection	landing Page URL - Dummy		ENTITYXVEHE	BN	Logo	Brand Logo	Jades	ASIN 1			2092	7	0.33%	3.87	26.29	1	1	0.14	14.72%	0.55	6.79	Campaign Name Video - Dummy			productList
3	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144372098095758078					enabled	running					1.1		Keyword - Dummy	exact													93	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
4	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144378212274492889					enabled	running					0.94		Keyword - Dummy	exact													1589	5	0.31%	2.97	0.0	0	0	0.0	0.0%	0.59	0.0	Campaign Name Video - Dummy	enabled
5	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144349493567945856					enabled	running					1.03		Keyword - Dummy	exact													7	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
6	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144293602967537195					enabled	running					0.94		Keyword - Dummy	exact													81	1	1.23%	0.4	26.29	1	1	1.0	1.52%	0.4	65.72	Campaign Name Video - Dummy	enabled
7	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144173063969897198					enabled	running					1.0		Keyword - Dummy	exact													54	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
8	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144298780982835075					draft	running					1.0		Keyword - Dummy	exact													54	1	1.85%	0.5	0.0	0	0	0.0	0.0%	0.5	0.0	Campaign Name Video - Dummy	enabled
9	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144357062320686516					enabled	landingPageNotAvailable					0.84		Keyword - Dummy	exact													1	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
10	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144297016457656202					enabled	other					1.04		Keyword - Dummy	exact													9	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
11	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144286744651493972					enabled	rejected					1.09		Keyword - Dummy	exact													15	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
12	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144290617996268743					enabled	paused					0.88		Keyword - Dummy	exact													2	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
13	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144255707837268039					enabled	running					0.96		Keyword - Dummy	exact													29	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
14	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144221665831038963					enabled	running					1.04		Keyword - Dummy	exact													148	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
15	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144212957208354004					enabled	running					0.83		Keyword - Dummy	exact													10	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
16	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144187332455549561					enabled	running					0.88		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
17	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144159290003358808					enabled	running					1.04		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
18	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144220138251748092					enabled	running					1.1		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
19	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144360855296515360					enabled	running					0.9		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
20	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144141620599935467					enabled	running					0.75		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
21	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144182096130976082					enabled	running					0.91		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
22	Sponsored Brands	Keyword						144339458603378004			144309432404803675	144193019913582740					enabled	running					0.84		Keyword - Dummy	exact													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
23	Sponsored Brands	Campaign						144359656924423683						Campaign Name - Dummy	20210129		enabled	running	daily	1000.0	Manual	-30.0%						productCollection	landing Page URL - Dummy		ENTITYXVEHE	BN	Logo	Brand Logo	Jades	ASIN 1			2687	13	0.48%	10.19	0.0	0	0	0.0	0.0%	0.78	0.0	Campaign Name Video - Dummy			productList
24	Sponsored Brands	Draft Campaign						144359656924423683			144174796670877999	144286090799536150					enabled	running					1.4		Keyword - Dummy	phrase													174	1	0.57%	0.77	0.0	0	0	0.0	0.0%	0.77	0.0	Campaign Name Video - Dummy	enabled
25	Sponsored Brands	Draft Keyword						144359656924423683			144174796670877999	144233483931118266					enabled	running					2.15		Keyword - Dummy	phrase													104	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
26	Sponsored Brands	Draft Negative Product Targeting						144359656924423683			144174796670877999	144309929199616381					enabled	running					0.9		Keyword - Dummy	phrase													278	3	1.08%	1.97	0.0	0	0	0.0	0.0%	0.66	0.0	Campaign Name Video - Dummy	enabled
27	Sponsored Brands	Draft Negative Keyword						144359656924423683			144174796670877999	144274264630301073					enabled	running					0.98		Keyword - Dummy	phrase													662	4	0.6%	3.12	0.0	0	0	0.0	0.0%	0.78	0.0	Campaign Name Video - Dummy	enabled
28	Sponsored Brands	Negative Product Targeting						144359656924423683			144174796670877999	144191978149020176					enabled	running					2.15		Keyword - Dummy	phrase													35	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Video - Dummy	enabled
29	Sponsored Brands	Negative Keyword						144359656924423683			144174796670877999	144190368913650152					enabled	running					0.66		Keyword - Dummy	phrase													375	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Headline - Dummy	enabled
30	Sponsored Brands	Draft Product Targeting						144359656924423683			144174796670877999	144178026777831270					enabled	running					0.49		Keyword - Dummy	phrase													443	1	0.23%	0.49	0.0	0	0	0.0	0.0%	0.49	0.0	Campaign Name Headline - Dummy	enabled
31	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144139517882481130					enabled	running					2.23		Keyword - Dummy	phrase													181	1	0.55%	0.85	0.0	0	0	0.0	0.0%	0.85	0.0	Campaign Name Headline - Dummy	enabled
32	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144368045801512022					enabled	running					0.6		Keyword - Dummy	phrase													51	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Headline - Dummy	enabled
33	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144377150914279163					enabled	running					0.4		Keyword - Dummy	phrase													149	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Headline - Dummy	enabled
34	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144233134194688311					enabled	running					1.4		Keyword - Dummy	phrase													15	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Headline - Dummy	enabled
35	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144159408567949418					enabled	running					1.72		Keyword - Dummy	phrase													220	3	1.36%	2.99	0.0	0	0	0.0	0.0%	1.0	0.0	Campaign Name Headline - Dummy	enabled
36	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144262400342677174					enabled	running					1.12		Keyword - Dummy	phrase													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Headline - Dummy	enabled
37	Sponsored Brands	Keyword						144359656924423683			144174796670877999	144381043297624636					paused	running					0.1		Keyword - Dummy	phrase													0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name Headline - Dummy	enabled
Sponsored Brands Campaigns

Sponsored Display Campaigns

Dummy Bulk Data.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO
1	Product	Entity	Operation					Targeting Id (Read only)	Campaign Name	Ad Group Name	Start Date	End Date	State	Tactic	Budget Type	Budget	SKU	ASIN	Ad Group Default Bid	Bid		Bid Optimization	Cost Type	Targeting Expression	Impressions	Clicks	Click-through Rate	Spend	Sales	Orders	Units	Conversion Rate	Acos	CPC	ROAS	Campaign Name (Informational only)	Ad Group Name (Informational only)	Campaign State (Informational only)	Ad Group State (Informational only)	Ad Group Default Bid (Informational only)	Resolved Targeting Expression (Informational only)
2	Sponsored Display	Campaign							Campaign Name - Dummy		20220102		enabled	T00020	daily	100.0							cpc		92	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
3	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					1.0			Optimize for page visits			92	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
4	Sponsored Display	Product Ad											enabled				SKU - Dummy								92	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
5	Sponsored Display	Product Targeting						227194678777309					enabled							0.4				B034EF6AF8	92	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.0	Targeting
6	Sponsored Display	Campaign							Campaign Name - Dummy		20211231		enabled	T00020	daily	100.0							cpc		60	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
7	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					0.3			Optimize for conversions			60	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
8	Sponsored Display	Product Ad											enabled				SKU - Dummy								60	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
9	Sponsored Display	Product Targeting						230883144642868					enabled							0.23				B034EF6AF8	60	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.3	Targeting
10	Sponsored Display	Campaign							Campaign Name - Dummy		20220122		enabled	T00020	daily	100.0							cpc		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
11	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					1.0			Optimize for page visits			0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
12	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
13	Sponsored Display	Product Targeting						280386515472526					enabled							0.11				B034EF6AF8	0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.0	Targeting
14	Sponsored Display	Campaign							Campaign Name - Dummy		20210106		enabled	T00020	daily	1000.0							cpc		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
15	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					0.04			Optimize for page visits			0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
16	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
17	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
18	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
19	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
20	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
21	Sponsored Display	Product Targeting						164471007331589					enabled											B034EF6AF8	0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.04	Targeting
22	Sponsored Display	Campaign							Campaign Name - Dummy		20211231		enabled	T00020	daily	100.0							cpc		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
23	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					0.2			Optimize for page visits			0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
24	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
25	Sponsored Display	Product Targeting						69674391945511					enabled							0.15				B034EF6AF8	0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	0.2	Targeting
26	Sponsored Display	Campaign							Campaign Name - Dummy		20220121		enabled	T00020	daily	100.0							cpc		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		enabled
27	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					1.0			Optimize for page visits			0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
28	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled
29	Sponsored Display	Product Targeting						141228261042562					enabled							0.06				B034EF6AF8	0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	enabled	enabled	1.0	Targeting
30	Sponsored Display	Campaign							Campaign Name - Dummy		20200708		paused	T00020	daily	300.0							cpc		0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy		paused
31	Sponsored Display	Ad Group								Ad Group Name - Dummy			enabled	T00020					0.49			Optimize for page visits			0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
32	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
33	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
34	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
35	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
36	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
37	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
38	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
39	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
40	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
41	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
42	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
43	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
44	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
45	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
46	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
47	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
48	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
49	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
50	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
51	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
52	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
53	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
54	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
55	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
56	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
57	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
58	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
59	Sponsored Display	Product Ad											enabled				SKU - Dummy								0	0	0.0%	0.0	0.0	0	0	0.0	0.0%	0.0	0.0	Campaign Name - Dummy	Ad Group Name - Dummy	paused	enabled
Sponsored Display Campaigns

 

[alansidman]

How is this not significantly different from this post

VBA Code for deleting complete rows if it has specific text

Hi, so I need to delete the complete row if specific criteria is met, the criteria is as follows, In a sheet named called "Data" If column B contains either of "John", "David", "Susan", "Macro", few of them, or all of them, then delete those specific rows leaving the others (Note: If any of...

www.mrexcel.com

You should be able to amend the original code solution to fit this request.

 

[An Quala]

How is this not significantly different from this post

VBA Code for deleting complete rows if it has specific text

Hi, so I need to delete the complete row if specific criteria is met, the criteria is as follows, In a sheet named called "Data" If column B contains either of "John", "David", "Susan", "Macro", few of them, or all of them, then delete those specific rows leaving the others (Note: If any of...

www.mrexcel.com

You should be able to amend the original code solution to fit this request.

The code was written for single sheet and I have tried different ways to be able to use that for 3 sheets but it's always giving error. I have been trying to fix the error. So it would be better if I just get it for all 3 sheets I think, also I wanted to do it reversely means exclude based on NOTs.

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: https://www.myonlinetraininghub.com...sed-on-the-given-criteria-in-excel-vba#p24506
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.