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

An Quala

Board Regular
Joined
Mar 21, 2022
Messages
146
Office Version
  1. 2021
Platform
  1. Windows
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
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAV
1ProductEntityOperationCampaign IdAd Group IdPortfolio IdAd Id (Read only)Keyword Id (Read only)Product Targeting Id (Read only)Campaign NameAd Group NameStart DateEnd DateTargeting TypeStateDaily BudgetSKUASINAd Group Default BidBidKeyword TextMatch TypeBidding StrategyPlacementPercentageProduct Targeting ExpressionImpressionsClicksClick-through RateSpendSalesOrdersUnitsConversion RateAcosCPCROASCampaign 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)
2Sponsored ProductsCampaign51810182230962Portfolio1Campaign Name - Dummy20220131MANUALenabled100.0Dynamic bids - down only2739100.37%5.00.0000.00.0%0.50.0Campaign Name - Dummyenabled
3Sponsored ProductsBidding Adjustment51810182230962Dynamic bids - down onlyplacementProductPage0.0248420.08%0.90.0000.00.0%0.450.0Campaign Name - Dummyenabled
4Sponsored ProductsBidding Adjustment51810182230962Dynamic bids - down onlyplacementTop0.011686.9%4.10.0000.00.0%0.510.0Campaign Name - Dummyenabled
5Sponsored ProductsAd Group51810182230962103843358501771Ad Group Name - Dummyenabled0.42739100.37%5.00.0000.00.0%0.50.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
6Sponsored ProductsProduct Ad51810182230962103843358501771187095918266508enabledSKU Name - Dummy2739100.37%5.00.0000.00.0%0.50.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
7Sponsored ProductsKeyword51810182230962103843358501771133091597391670enabled0.58Keyword - Dummybroad000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
8Sponsored ProductsKeyword5181018223096210384335850177120484689160127enabled0.64Keyword - Dummybroad2085100.48%5.00.0000.00.0%0.50.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
9Sponsored ProductsKeyword51810182230962103843358501771147161619594891enabled0.58Keyword - Dummybroad2300.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
10Sponsored ProductsKeyword51810182230962103843358501771 117074780596747enabled0.62Keyword - Dummybroad39400.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
11Sponsored ProductsKeyword51810182230962103843358501771198054310782002enabled0.64Keyword - Dummybroad000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
12Sponsored ProductsNegative Product Targeting51810182230962103843358501771216796694767871enabled0.64Keyword - Dummybroad23100.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
13Sponsored ProductsProduct Targeting51810182230962103843358501771116800394856451enabled0.64Keyword - Dummybroad600.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.4
14Sponsored ProductsCampaign224654867824700Portfolio1Campaign Name - Dummy20220101MANUALenabled100.0Dynamic bids - down only4800.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
15Sponsored ProductsBidding Adjustment224654867824700Dynamic bids - down onlyplacementProductPage0.03900.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
16Sponsored ProductsBidding Adjustment224654867824700Dynamic bids - down onlyplacementTop0.0000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
17Sponsored ProductsAd Group224654867824700186267109368336Ad Group Name - Dummyenabled1.14800.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
18Sponsored ProductsProduct Ad22465486782470018626710936833652184089599015enabledSKU Name - Dummy4800.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
19Sponsored ProductsKeyword22465486782470018626710936833683911309498353enabled1.08Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
20Sponsored ProductsKeyword22465486782470018626710936833653354652434783enabled1.08Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
21Sponsored ProductsKeyword2246548678247001862671093683362712747284010enabled0.97Keyword - Dummyexact3400.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
22Sponsored ProductsKeyword2246548678247001862671093683368880509831632enabled0.97Keyword - Dummyexact200.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
23Sponsored ProductsKeyword22465486782470018626710936833629871655919998enabled1.08Keyword - Dummyexact100.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
24Sponsored ProductsKeyword224654867824700186267109368336207922361834615enabled1.57Keyword - Dummyexact1000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
25Sponsored ProductsKeyword22465486782470018626710936833682552476516641enabled0.8Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
26Sponsored ProductsKeyword224654867824700186267109368336125041523559069enabled1.08Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
27Sponsored ProductsKeyword224654867824700186267109368336178224892278959enabled1.17Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
28Sponsored ProductsKeyword224654867824700186267109368336237702370532591enabled1.25Keyword - Dummyexact100.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.1
29Sponsored ProductsCampaign60228050322464Portfolio2Campaign Name - Dummy20211221MANUALenabled100.0Dynamic bids - down only100.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
30Sponsored ProductsBidding Adjustment60228050322464Dynamic bids - down onlyplacementProductPage0.0100.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
31Sponsored ProductsBidding Adjustment60228050322464Dynamic bids - down onlyplacementTop0.0000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
32Sponsored ProductsAd Group60228050322464225369445700841Ad Group Name - Dummyenabled0.06100.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
33Sponsored ProductsProduct Ad60228050322464225369445700841101252162650765enabledSKU Name - Dummy100.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
34Sponsored ProductsKeyword60228050322464225369445700841232179385161330enabled0.11Keyword - Dummyphrase100.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.06
Sponsored Products Campaigns
 

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Other 2 sheets

Sponsored Brands Campaigns

Dummy Bulk Data.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZBA
1ProductEntityOperationCampaign IdDraft Campaign IdPortfolio IdAd Group Id (Read only)Keyword Id (Read only)Product Targeting Id (Read only)Campaign NameStart DateEnd DateStateCampaign Serving Status (Informational only)Budget TypeBudgetBid OptimizationBid MultiplierBidKeyword TextMatch TypeProduct Targeting ExpressionAd FormatLanding Page URLLanding Page AsinsBrand Entity IdBrand NameBrand Logo Asset IdBrand Logo URLCreative HeadlineCreative ASINsVideo Media IdsCreative TypeImpressionsClicksClick-through RateSpendSalesOrdersUnitsConversion RateAcosCPCROASCampaign Name (Informational only)Campaign State (Informational only)Resolved Product Targeting Expression (Informational only)Landing Page Type (Informational only)
2Sponsored BrandsCampaign144339458603378004Campaign Name - Dummy20210130enabledrunningdaily1000.0Manual-30.0%productCollectionlanding Page URL - DummyENTITYXVEHEBNLogoBrand LogoJadesASIN 1209270.33%3.8726.29110.1414.72%0.556.79Campaign Name Video - DummyproductList
3Sponsored BrandsKeyword144339458603378004144309432404803675144372098095758078enabledrunning1.1Keyword - Dummyexact9300.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
4Sponsored BrandsKeyword144339458603378004144309432404803675144378212274492889enabledrunning0.94Keyword - Dummyexact158950.31%2.970.0000.00.0%0.590.0Campaign Name Video - Dummyenabled
5Sponsored BrandsKeyword144339458603378004144309432404803675144349493567945856enabledrunning1.03Keyword - Dummyexact700.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
6Sponsored BrandsKeyword144339458603378004144309432404803675144293602967537195enabledrunning0.94Keyword - Dummyexact8111.23%0.426.29111.01.52%0.465.72Campaign Name Video - Dummyenabled
7Sponsored BrandsKeyword144339458603378004144309432404803675144173063969897198enabledrunning1.0Keyword - Dummyexact5400.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
8Sponsored BrandsKeyword144339458603378004144309432404803675144298780982835075draftrunning1.0Keyword - Dummyexact5411.85%0.50.0000.00.0%0.50.0Campaign Name Video - Dummyenabled
9Sponsored BrandsKeyword144339458603378004144309432404803675144357062320686516enabledlandingPageNotAvailable0.84Keyword - Dummyexact100.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
10Sponsored BrandsKeyword144339458603378004144309432404803675144297016457656202enabledother1.04Keyword - Dummyexact900.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
11Sponsored BrandsKeyword144339458603378004144309432404803675144286744651493972enabledrejected1.09Keyword - Dummyexact1500.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
12Sponsored BrandsKeyword144339458603378004144309432404803675144290617996268743enabledpaused0.88Keyword - Dummyexact200.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
13Sponsored BrandsKeyword144339458603378004144309432404803675144255707837268039enabledrunning0.96Keyword - Dummyexact2900.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
14Sponsored BrandsKeyword144339458603378004144309432404803675144221665831038963enabledrunning1.04Keyword - Dummyexact14800.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
15Sponsored BrandsKeyword144339458603378004144309432404803675144212957208354004enabledrunning0.83Keyword - Dummyexact1000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
16Sponsored BrandsKeyword144339458603378004144309432404803675144187332455549561enabledrunning0.88Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
17Sponsored BrandsKeyword144339458603378004144309432404803675144159290003358808enabledrunning1.04Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
18Sponsored BrandsKeyword144339458603378004144309432404803675144220138251748092enabledrunning1.1Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
19Sponsored BrandsKeyword144339458603378004144309432404803675144360855296515360enabledrunning0.9Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
20Sponsored BrandsKeyword144339458603378004144309432404803675144141620599935467enabledrunning0.75Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
21Sponsored BrandsKeyword144339458603378004144309432404803675144182096130976082enabledrunning0.91Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
22Sponsored BrandsKeyword144339458603378004144309432404803675144193019913582740enabledrunning0.84Keyword - Dummyexact000.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
23Sponsored BrandsCampaign144359656924423683Campaign Name - Dummy20210129enabledrunningdaily1000.0Manual-30.0%productCollectionlanding Page URL - DummyENTITYXVEHEBNLogoBrand LogoJadesASIN 12687130.48%10.190.0000.00.0%0.780.0Campaign Name Video - DummyproductList
24Sponsored BrandsDraft Campaign144359656924423683144174796670877999144286090799536150enabledrunning1.4Keyword - Dummyphrase17410.57%0.770.0000.00.0%0.770.0Campaign Name Video - Dummyenabled
25Sponsored BrandsDraft Keyword144359656924423683144174796670877999144233483931118266enabledrunning2.15Keyword - Dummyphrase10400.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
26Sponsored BrandsDraft Negative Product Targeting144359656924423683144174796670877999144309929199616381enabledrunning0.9Keyword - Dummyphrase27831.08%1.970.0000.00.0%0.660.0Campaign Name Video - Dummyenabled
27Sponsored BrandsDraft Negative Keyword144359656924423683144174796670877999144274264630301073enabledrunning0.98Keyword - Dummyphrase66240.6%3.120.0000.00.0%0.780.0Campaign Name Video - Dummyenabled
28Sponsored BrandsNegative Product Targeting144359656924423683144174796670877999144191978149020176enabledrunning2.15Keyword - Dummyphrase3500.0%0.00.0000.00.0%0.00.0Campaign Name Video - Dummyenabled
29Sponsored BrandsNegative Keyword144359656924423683144174796670877999144190368913650152enabledrunning0.66Keyword - Dummyphrase37500.0%0.00.0000.00.0%0.00.0Campaign Name Headline - Dummyenabled
30Sponsored BrandsDraft Product Targeting144359656924423683144174796670877999144178026777831270enabledrunning0.49Keyword - Dummyphrase44310.23%0.490.0000.00.0%0.490.0Campaign Name Headline - Dummyenabled
31Sponsored BrandsKeyword144359656924423683144174796670877999144139517882481130enabledrunning2.23Keyword - Dummyphrase18110.55%0.850.0000.00.0%0.850.0Campaign Name Headline - Dummyenabled
32Sponsored BrandsKeyword144359656924423683144174796670877999144368045801512022enabledrunning0.6Keyword - Dummyphrase5100.0%0.00.0000.00.0%0.00.0Campaign Name Headline - Dummyenabled
33Sponsored BrandsKeyword144359656924423683144174796670877999144377150914279163enabledrunning0.4Keyword - Dummyphrase14900.0%0.00.0000.00.0%0.00.0Campaign Name Headline - Dummyenabled
34Sponsored BrandsKeyword144359656924423683144174796670877999144233134194688311enabledrunning1.4Keyword - Dummyphrase1500.0%0.00.0000.00.0%0.00.0Campaign Name Headline - Dummyenabled
35Sponsored BrandsKeyword144359656924423683144174796670877999144159408567949418enabledrunning1.72Keyword - Dummyphrase22031.36%2.990.0000.00.0%1.00.0Campaign Name Headline - Dummyenabled
36Sponsored BrandsKeyword144359656924423683144174796670877999144262400342677174enabledrunning1.12Keyword - Dummyphrase000.0%0.00.0000.00.0%0.00.0Campaign Name Headline - Dummyenabled
37Sponsored BrandsKeyword144359656924423683144174796670877999144381043297624636pausedrunning0.1Keyword - Dummyphrase000.0%0.00.0000.00.0%0.00.0Campaign Name Headline - Dummyenabled
Sponsored Brands Campaigns


Sponsored Display Campaigns

Dummy Bulk Data.xlsx
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJAKALAMANAO
1ProductEntityOperationTargeting Id (Read only)Campaign NameAd Group NameStart DateEnd DateStateTacticBudget TypeBudgetSKUASINAd Group Default BidBidBid OptimizationCost TypeTargeting ExpressionImpressionsClicksClick-through RateSpendSalesOrdersUnitsConversion RateAcosCPCROASCampaign 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)
2Sponsored DisplayCampaignCampaign Name - Dummy20220102enabledT00020daily100.0cpc9200.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
3Sponsored DisplayAd GroupAd Group Name - DummyenabledT000201.0Optimize for page visits9200.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
4Sponsored DisplayProduct AdenabledSKU - Dummy9200.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
5Sponsored DisplayProduct Targeting227194678777309enabled0.4B034EF6AF89200.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.0Targeting
6Sponsored DisplayCampaignCampaign Name - Dummy20211231enabledT00020daily100.0cpc6000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
7Sponsored DisplayAd GroupAd Group Name - DummyenabledT000200.3Optimize for conversions6000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
8Sponsored DisplayProduct AdenabledSKU - Dummy6000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
9Sponsored DisplayProduct Targeting230883144642868enabled0.23B034EF6AF86000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.3Targeting
10Sponsored DisplayCampaignCampaign Name - Dummy20220122enabledT00020daily100.0cpc000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
11Sponsored DisplayAd GroupAd Group Name - DummyenabledT000201.0Optimize for page visits000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
12Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
13Sponsored DisplayProduct Targeting280386515472526enabled0.11B034EF6AF8000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.0Targeting
14Sponsored DisplayCampaignCampaign Name - Dummy20210106enabledT00020daily1000.0cpc000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
15Sponsored DisplayAd GroupAd Group Name - DummyenabledT000200.04Optimize for page visits000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
16Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
17Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
18Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
19Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
20Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
21Sponsored DisplayProduct Targeting164471007331589enabledB034EF6AF8000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.04Targeting
22Sponsored DisplayCampaignCampaign Name - Dummy20211231enabledT00020daily100.0cpc000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
23Sponsored DisplayAd GroupAd Group Name - DummyenabledT000200.2Optimize for page visits000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
24Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
25Sponsored DisplayProduct Targeting69674391945511enabled0.15B034EF6AF8000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled0.2Targeting
26Sponsored DisplayCampaignCampaign Name - Dummy20220121enabledT00020daily100.0cpc000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummyenabled
27Sponsored DisplayAd GroupAd Group Name - DummyenabledT000201.0Optimize for page visits000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
28Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled
29Sponsored DisplayProduct Targeting141228261042562enabled0.06B034EF6AF8000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummyenabledenabled1.0Targeting
30Sponsored DisplayCampaignCampaign Name - Dummy20200708pausedT00020daily300.0cpc000.0%0.00.0000.00.0%0.00.0Campaign Name - Dummypaused
31Sponsored DisplayAd GroupAd Group Name - DummyenabledT000200.49Optimize for page visits000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
32Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
33Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
34Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
35Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
36Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
37Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
38Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
39Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
40Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
41Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
42Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
43Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
44Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
45Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
46Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
47Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
48Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
49Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
50Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
51Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
52Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
53Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
54Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
55Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
56Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
57Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
58Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
59Sponsored DisplayProduct AdenabledSKU - Dummy000.0%0.00.0000.00.0%0.00.0Campaign Name - DummyAd Group Name - Dummypausedenabled
Sponsored Display Campaigns
 
Upvote 0
How is this not significantly different from this post

You should be able to amend the original code solution to fit this request.
 
Upvote 0
How is this not significantly different from this post

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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,223,891
Messages
6,175,229
Members
452,621
Latest member
Laura_PinksBTHFT

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top