Find and Highlight Match Between 2 Workbook

VBA_Noob01

New Member
Joined
Oct 21, 2021
Messages
1
Office Version
  1. 2019
  2. 2016
Platform
  1. Windows
Good day friends!

I would like some help on my problem. I have 2 workbooks (Workbook 1 is the data that needs to be highlighted, Workbook 2 is an Excel Add-in (.xlam) I made in which I inserted a Sheet that contains the source or the database.

I want to highlight the cell using VBA the Workbook 1, under table named "table1" and column "Offense", see attached:

Workbook 1.xlsx
MNO
1STAGES OF FELONYOFFENSEOFFENSE CATEGORY
2ABANDONING A MINOR - RPC Art. 276
3ABANDONMENT OF MINOR BY PERSON ENTRUSTED WITH HIS CUSTODY; INDIFFERENCE OF PARENTS - RPC Art. 277
4ABORTION PRACTICED BY A PHYSICIAN OR MIDWIFE AND DISPENSING OF ABORTIVES - RPC Art. 259
5ACCESS DEVICES REGULATION ACT OF 1998 (CREDIT CARD VIOLATION ACT) - RA 8484 as amended by RA 11449
6ACTS OF LASCIVIOUSNESS - RPC Art. 336
7ACTS OF LASCIVIOUSNESS WITH THE CONSENT OF THE OFFENDED PARTY - RPC Art 339
8ADULTERY - RPC Art. 333
9ALARMS AND SCANDALS - RPC Art. 155
10AN ACT DEFINING AND PENALIZING CERTAIN PROHIBITED ACTS INIMICAL TO THE PUBLIC INTERESTS AND NATIONAL SECURITY INVOLVING PETROLEUM AND/OR PETROLEUM PRODUCTS, PRESCRIBING PENALTIES THEREFOR AND FOR OTHER PURPOSES`, BY INCLUDING SHORT-SELLING AND ADULTE - PD 1865
11AN ACT INCREASING THE PENALTIES FOR ILLEGAL NUMBERS GAMES, AMENDING CERTAIN PROVISIONS OF PRESIDENTIAL DECREE NO. 1602, AND FOR OTHER PURPOSES - RA 9287 amending pd 1602
12AN ACT REGULATING THE SALE, MANUFACTURE, DISTRIBUTION AND USE OF FIRECRACKERS AND OTHER PYROTECHNIC DEVICES - RA 7183
13ANIMAL WELFARE ACT OF 1998 - RA 8485
14ANTI-BULLYING ACT OF 2013 - RA 10627
15ANTI-CABLE TELEVISION AND CABLE INTERNET TAPPING ACT OF 2013 - RA 10515
16ANTI-CATTLE RUSTLING LAW OF 1974 - PD 533
17ANTI-CHILD PORNOGRAPHY ACT OF 2009 - RA 9775
18ANTI-DRUNK AND DRUGGED DRIVING ACT OF 2013 - RA 10586
19ANTI-ELECTRICITY AND ELECTRIC TRANSMISSION LINES/MATERIALS PILFERAGE ACT OF 1994 - RA 7832
20ANTI-FENCING LAW 0F 1979 - RA 1612
21ANTI-FENCING LAW OF 1979 - PD 1612
22ANTI-GAMBLING LAW - PD 1602
23ANTI-GRAFT AND CORRUPT PRACTICES ACT - RA 3019 as amended by BP Blg 195
24ANTI-HAZING LAW - RA 8049
25ANTI-HIGHWAY ROBBERY LAW OF 1974 - PD 532
26ANTI-PHOTO AND VIDEO VOYEURISM ACT OF 2009 - RA 9995
27ANTI-RABIES ACT OF 2007 - RA 9482
28ANTI-RAPE LAW OF 1997 - RA 8353RAPE
29ANTI-RAPE LAW OF 1997 - RA 8353RAPE
30ANTI-RAPE LAW OF 1997 - RA 8353RAPE
31ANTI-RAPE LAW OF 1997 - RA 8353RAPE
32ANTI-RAPE LAW OF 1997 - RA 8353RAPE
33ANTI-RAPE LAW OF 1997 - RA 8353RAPE
34ANTI-RED TAPE ACT OF 2007 - RA 9485
35ANTI-TRAFFICKING IN PERSONS ACT OF 2003 - RA 9208 as amended by RA 10364 (Expanded ATIP)
36ANTI-VIOLENCE AGAINST WOMEN AND THEIR CHILDREN ACT OF 2004 - RA 9262
37ARSON OF PROPERTY OF SMALL VALUE - RPC Art. 323
38BAYANIHAN HEAL AS ONE ACT - RA 11469
39BIGAMY - RPC Art. 349
40BOUNCING CHECK LAW - BP 22
41BURNING ONE'S OWN PROPERTY AS MEANS TO COMMIT ARSON - RPC Art. 325
42CHAIN SAW ACT OF 2002 - RA 9175
43CHALLENGING TO A DUEL - RPC Art. 261
44****FIGHTING LAW OF 1974 - PD 449
45COCONUT PRESERVATION ACT OF 1995 - RA 8048 as amended by RA 10593
46CODE OF CONDUCT AND ETHICAL STANDARDS FOR PUBLIC OFFICIALS AND EMPLOYEES - RA 6713
47CODE ON SANITATION OF THE PHILIPPINES - PD 856
48COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - RA 9165
49COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - CULTIVATION OR CULTURE OF PLANTS CLASSIFIED AS DANGEROUS DRUGS OR ARE SOURCES THEREOF - RA 9165 Article II Section 16 para 1
50COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - IMPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 4 para 1
51COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS - RA 9165 Article II Section 11
52COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS DURING PARTIES, SOCIAL GATHERINGS OR MEETINGS - RA 9165 Article II Section 13
53COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF EQUIPMENT, INSTRUMENT, APPARATUS AND OTHER PARAPHERNALIA FOR DANGEROUS DRUGS - RA 9165 Article II Section 12
54COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - SALE, TRADING, ADMINISTRATION, DISPENSATION, DELIVERY, DISTRIBUTION AND TRANSPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 5 para 1
55COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - USE OF DANGEROUS DRUGS - RA 9165 Article II Section 15
56COMPREHENSIVE LAW ON FIREARMS AND AMMUNITION - RA 10591 (covers RA 9516, RA 8294 and PD 1866)
57CUSTOMS MODERNIZATION AND TARIFF ACT (CMTA) - RA 10863
58CYBERCRIME PREVENTION ACT OF 2012 - RA 10175
59DAMAGE AND OBSTRUCTION TO MEANS OF COMMUNICATION - RPC Art. 330
60DATA PRIVACY ACT OF 2012 - RA 10173
61EXPANDED ANTI-TRAFFICKING IN PERSONS ACT OF 2012 - RA 10364
62FOOD AND DRUG ADMINISTRATION ACT OF 2009 - RA 9711
63FURTHER AMENDING ARTICLES 38 AND 39 OF THE LABOR CODE BY MAKING ILLEGAL RECRUITMENT A CRIME OF ECONOMIC SABOTAGE AND PUNISHABLE WITH LIFE IMPRISONMENT. - PD 2018
64HOMICIDE - RPC Art. 249HOMICIDE
65HOMICIDE - RPC Art. 249HOMICIDE
66ILLEGAL COMMERCIAL IMPORTATION OF USED CLOTHING AND RAGS - RA 4653
67ILLEGAL FISHING / THE PHILIPPINE FISHERIES CODE OF 1998 - RA 8550 as amended by RA 10654
68ILLEGAL POSSESSION OF BLADED, POINTED OR BLUNT WEAPONS - BP 6
69ILLEGAL POSSESSION, MANUFACTURE, ACQUISITION, OF FIREARMS, AMMUNITION OR EXPLOSIVES - PD 1866 as amended by RA 8294 and RA 9516
70JUVENILE JUSTICE AND WELFARE ACT OF 2006 - RA 9344
71LAND TRANSPORTATION AND TRAFFIC CODE (COMPULSARY REGISTRATION OF MOTOR VEHICLES) - RPC Art. 4136 as amended by BP Blg 74
72LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265PHYSICAL INJURIES
73LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265PHYSICAL INJURIES
74LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265PHYSICAL INJURIES
75MALICIOUS DISSEMINATION OF FALSE INFORMATION OF THE WILLFUL MAKING OF ANY THREAT CONCERNING BOMBS, EXPLOSIVES OR ANY SIMILAR DEVICE OR MEANS OF DESTRUCTION AND IMPOSING PENALTIES THEREFOR. - PD 1727
76MANDATORY REPORTING OF NOTIFIABLE DISEASES AND HEALTH EVENTS OF PUBLIC HEALTH CONCERN ACT - RA 11332
77MOTORCYCLE HELMET ACT OF 2009 - RA 10054
78MURDER - RPC Art. 248MURDER
79MURDER - RPC Art. 248MURDER
80OMNIBUS ELECTION CODE OF THE PHILIPPINES - BP 881
81PARRICIDE - RPC Art. 246MURDER
82PENALIZING OBSTRUCTION OF APPREHENSION AND PROSECUTION OF CRIMINAL OFFENDERS. - PD 1829
83PENALIZING THE UNAUTHORIZED INSTALLATION OF WATER, ELECTRICAL OR TELEPHONE CONNECTIONS, THE USE OF TAMPERED WATER OR ELECTRICAL METERS, AND OTHER ACTS - PD 401
84PENALIZING THE USE OR POSSESSION OR THE UNAUTHORIZED SALE TO MINORS OF VOLATILE SUBSTANCES FOR THE PURPOSE OF INDUCING INTOXICATION OR IN ANY MANNER CHANGING, DISTORTING OR DISTURBING THE AUDITORY, VISUAL OR MENTAL PROCESS - PD 1619
85PEOPLE'S SMALL-SCALE MINING ACT OF 1991 - RA 7076
86PHILIPPINE FISHERIES CODE - RA 10654
87PHILIPPINE MINING ACT OF 1995 - RA 7942
88PHILIPPINE PASSPORT ACT OF 1996 - RA 8239
89PRICE ACT - RA 7581
90PROVIDING FOR THE ESTABLISHMENT OF SMOKE-FREE ENVIRONMENTS IN PUBLIC AND ENCLOSED PLACES - EO 26 in relation to RA 8749 and RA 9211
91QUARANTINE ACT OF 2004 - RA 9271
92RAPE - RPC Art 266-ARAPE
93RAPE - RPC Art 266-ARAPE
94REVISED FORESTRY CODE OF THE PHILIPPINES - PD 705
95SAFE SPACES ACT (GENDER BASED SEXUAL HARASSMENT) - RA 11313
96SEXUAL HARRASSMENT ACT OF 1995 - RA 7877
97SLIGHT PHYSICAL INJURIES AND MALTREATMENT - RPC Art. 266PHYSICAL INJURIES
98SPECIAL PROTECTION OF CHILDREN AGAINST CHILD ABUSE, EXPLOITATION AND DISCRIMINATION ACT. (ANTI- CHILD ABUSE LAW) - RA 7610
99TARIFF AND CUSTOMS LAWS (ANTI-SMUGGLING) - PD 1464
100THE ANTI-SQUATTING LAW REPEAL ACT OF 1997 - RA 8368
101THE CONSUMER ACT OF THE PHILIPPINES - RA 7394
102THE FORESTRY REFORM CODE OF THE PHILIPPINES (ILLEGAL LOGGING) - PD 705
103THE HUMAN SECURITY ACT OF 2007 - RA 9372
104THE INTELLECTUAL PROPERTY CODE OF THE PHILIPPINES (THE COPYRIGHT LAW). - RA 8293
105THE MEAT INSPECTION CODE OF THE PHILIPPINES - RA 9296
106THE PHILIPPINE DENTAL ACT OF 2007 - RA 9484
107THE SECURITIES REGULATION CODE - RA 8799
108THEFT - RPC Art. 308THEFT
109THEFT - RPC Art. 308THEFT
110THEFT - RPC Art. 308THEFT
111TOBACCO REGULATION ACT OF 2003 - RA 9211
112URBAN DEVELOPMENT AND HOUSING ACT OF 1992 - RA 7279
113VIOLATION OF MAGNA CARTA FOR DISABLED PERSON - RA 7277 AS AMENDED BY ra 9442
114WILDLIFE RESOURCES CONSERVATION AND PROTECTION ACT - RA 9147
Detailed_Report



by comparing it to source (Workbook 2) under table named "tb_source" column "Index_Crimes". See attached.
Source.xlsm
BCDE
4Index_Crimesother_nicspl_nicrir
5ANTI-RAPE LAW OF 1997 - RA 8353ABANDONING A MINOR - RPC Art. 276ACCESS DEVICES REGULATION ACT OF 1998 (CREDIT CARD VIOLATION ACT) - RA 8484 as amended by RA 11449IMPRUDENCE AND NEGLIGENCE (RECKLESS IMPRUDENCE) - RPC Art. 365
6ARSON WITH HOMICIDE - RPC Art. 320 amended by PD 1613 and PD 1744ABANDONMENT OF MINOR BY PERSON ENTRUSTED WITH HIS CUSTODY; INDIFFERENCE OF PARENTS - RPC Art. 277AN ACT DEFINING AND PENALIZING CERTAIN PROHIBITED ACTS INIMICAL TO THE PUBLIC INTERESTS AND NATIONAL SECURITY INVOLVING PETROLEUM AND/OR PETROLEUM PRODUCTS, PRESCRIBING PENALTIES THEREFOR AND FOR OTHER PURPOSES`, BY INCLUDING SHORT-SELLING AND ADULTE - PD 1865RECKLESS IMPRUDENCE RESULTING TO DAMAGE TO PROPERTY - RPC Art 365
7HOMICIDE - RPC Art. 249ABORTION PRACTICED BY A PHYSICIAN OR MIDWIFE AND DISPENSING OF ABORTIVES - RPC Art. 259AN ACT INCREASING THE PENALTIES FOR ILLEGAL NUMBERS GAMES, AMENDING CERTAIN PROVISIONS OF PRESIDENTIAL DECREE NO. 1602, AND FOR OTHER PURPOSES - RA 9287 amending pd 1602RECKLESS IMPRUDENCE RESULTING TO HOMICIDE - RPC Art 365
8INFANTICIDE - RPC Art. 255ACTS OF LASCIVIOUSNESS - RPC Art. 336AN ACT REGULATING THE SALE, MANUFACTURE, DISTRIBUTION AND USE OF FIRECRACKERS AND OTHER PYROTECHNIC DEVICES - RA 7183RECKLESS IMPRUDENCE RESULTING TO MULTIPLE DAMAGE TO PROPERTY - RPC Art 365
9LESS SERIOUS PHYSICAL INJURIES - RPC Art. 265ACTS OF LASCIVIOUSNESS WITH THE CONSENT OF THE OFFENDED PARTY - RPC Art 339ANIMAL WELFARE ACT OF 1998 - RA 8485RECKLESS IMPRUDENCE RESULTING TO MULTIPLE HOMICIDE - RPC Art 365
10MURDER - RPC Art. 248ADULTERY - RPC Art. 333ANTI-CABLE TELEVISION AND CABLE INTERNET TAPPING ACT OF 2013 - RA 10515RECKLESS IMPRUDENCE RESULTING TO MULTIPLE PHYSICAL INJURY - RPC Art 365
11NEW ANTI-CARNAPPING ACT OF 2016 - MC - RA 10883 (repealed RA 6539)ALARMS AND SCANDALS - RPC Art. 155ANTI-CATTLE RUSTLING LAW OF 1974 - PD 533RECKLESS IMPRUDENCE RESULTING TO PHYSICAL INJURY - RPC Art 365
12NEW ANTI-CARNAPPING ACT OF 2016 - MV - RA 10883 (repealed RA 6539)ARSON OF PROPERTY OF SMALL VALUE - RPC Art. 323ANTI-CHILD PORNOGRAPHY ACT OF 2009 - RA 9775
13NEW ANTI-CARNAPPING ACT OF 2016 - OWNER, DRIVER OR OCCUPANT VEHICLE IS KILLED OR RAPED - MC - RA 10883 (repealed RA 6539)BIGAMY - RPC Art. 349ANTI-DRUNK AND DRUGGED DRIVING ACT OF 2013 - RA 10586
14NEW ANTI-CARNAPPING ACT OF 2016 - OWNER, DRIVER OR OCCUPANT VEHICLE IS KILLED OR RAPED - MV - RA 10883 (repealed RA 6539)BURNING ONE'S OWN PROPERTY AS MEANS TO COMMIT ARSON - RPC Art. 325ANTI-ELECTRICITY AND ELECTRIC TRANSMISSION LINES/MATERIALS PILFERAGE ACT OF 1994 - RA 7832
15PARRICIDE - RPC Art. 246CHALLENGING TO A DUEL - RPC Art. 261ANTI-FENCING LAW 0F 1979 - RA 1612
16QUALIFIED RAPE - RPC Art 266-BCONCUBINAGE - RPC Art. 334ANTI-FENCING LAW OF 1979 - PD 1612
17QUALIFIED THEFT - RPC Art. 310 as amended by BP Blg 71CONSENTED ABDUCTION - RPC Art. 343ANTI-GAMBLING LAW - PD 1602
18RAPE - RPC Art 266-ACORRUPTION OF PUBLIC OFFICIALS - RPC Art. 212ANTI-GRAFT AND CORRUPT PRACTICES ACT - RA 3019 as amended by BP Blg 195
19RAPE WITH HOMICIDE - RPC Art. 266-BCOUNTERFEITING THE GREAT SEAL OF THE GOVERNMENT OF THE PHILIPPINE ISLANDS, FORGING THE SIGNATURE OR STAMP OF THE CHIEF EXECUTIVE - RPC Art. 161ANTI-HAZING LAW - RA 8049
20ROBBERY - RPC Art. 293CRIMES INVOLVING DESTRUCTION - RPC Art. 324ANTI-HIGHWAY ROBBERY LAW OF 1974 - PD 532
21ROBBERY IN AN INHABITED HOUSE OR PUBLIC BUILDING OR EDIFICE DEVOTED TO WORSHIP - RPC Art. 299DELIVERY OF PRISONERS FROM JAILS - RPC Art. 156ANTI-PHOTO AND VIDEO VOYEURISM ACT OF 2009 - RA 9995
22ROBBERY IN AN UNINHABITED PLACE AND BY A BAND - RPC Art. 300DESTRUCTIVE ARSON - RPC Art. 320 amended by PD 1613 and PD 1744ANTI-RABIES ACT OF 2007 - RA 9482
23ROBBERY IN AN UNINHABITED PLACE OR IN A PRIVATE BUILDING - RPC Art. 302DIRECT ASSAULTS - RPC Art. 148ANTI-RED TAPE ACT OF 2007 - RA 9485
24ROBBERY WITH HOMICIDE - RPC Art. 294DIRECT BRIBERY - RPC Art. 210ANTI-TRAFFICKING IN PERSONS ACT OF 2003 - RA 9208 as amended by RA 10364 (Expanded ATIP)
25ROBBERY WITH SERIOUS PHYSICAL INJURIES - RPC Art. 294DISCHARGE OF FIREARMS - RPC Art 254ANTI-VIOLENCE AGAINST WOMEN AND THEIR CHILDREN ACT OF 2004 - RA 9262
26ROBBERY WITH VIOLENCE AGAINST OR INTIMIDATION OF PERSONS - RPC Art. 294DISTURBANCE OF PROCEEDINGS - RPC Art. 144BAYANIHAN HEAL AS ONE ACT - RA 11469
27SERIOUS PHYSICAL INJURIES - RPC Art. 263ESCAPE OF PRISONER UNDER THE CUSTODY OF A PERSON NOT A PUBLIC - RPC Art. 225BOUNCING CHECK LAW - BP 22
28SLIGHT PHYSICAL INJURIES AND MALTREATMENT - RPC Art. 266EVASION THROUGH NEGLIGENCE - RPC Art. 224CHAIN SAW ACT OF 2002 - RA 9175
29THEFT - RPC Art. 308EXECUTION OF DEEDS BY MEANS OF VIOLENCE OR INTIMIDATION - RPC Art. 298****FIGHTING LAW OF 1974 - PD 449
30EXPLOITATION OF CHILD LABOR - RPC Art. 273COCONUT PRESERVATION ACT OF 1995 - RA 8048 as amended by RA 10593
31FALSE TESTIMONY IN OTHER CASES AND PERJURY IN SOLEMN AFFIRMATION - RPC Art. 183CODE OF CONDUCT AND ETHICAL STANDARDS FOR PUBLIC OFFICIALS AND EMPLOYEES - RA 6713
32FALSIFICATION BY PRIVATE INDIVIDUAL AND USE OF FALSIFIED DOCUMENTS - RPC Art. 172CODE ON SANITATION OF THE PHILIPPINES - PD 856
33FORCIBLE ABDUCTION - RPC Art. 342COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - RA 9165
34GRAVE COERCIONS - RPC Art. 286 amended by 3815 and RA 7890COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - CULTIVATION OR CULTURE OF PLANTS CLASSIFIED AS DANGEROUS DRUGS OR ARE SOURCES THEREOF - RA 9165 Article II Section 16 para 1
35GRAVE SCANDAL - RPC Art. 200COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - IMPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 4 para 1
36GRAVE THREATS - RPC Art. 282COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS - RA 9165 Article II Section 11
37HIGHGRADING OR THEFT OF GOLD FROM A MINING CLAIM OR MINING CAMP (PRESCRIBING A HEAVIER MINIMUM PENALTY FOR) - PD 581COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF DANGEROUS DRUGS DURING PARTIES, SOCIAL GATHERINGS OR MEETINGS - RA 9165 Article II Section 13
38ILLEGAL POSSESSION AND USE OF FALSE TREASURY OR BANK NOTES AND OTHER INSTRUMENTS OF CREDIT - RPC Art. 168COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - POSSESSION OF EQUIPMENT, INSTRUMENT, APPARATUS AND OTHER PARAPHERNALIA FOR DANGEROUS DRUGS - RA 9165 Article II Section 12
39ILLEGAL USE OF UNIFORMS OR INSIGNIA - RPC Art. 179COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - SALE, TRADING, ADMINISTRATION, DISPENSATION, DELIVERY, DISTRIBUTION AND TRANSPORTATION OF DANGEROUS DRUGS - RA 9165 Article II Section 5 para 1
40INDIRECT ASSAULTS - RPC Art. 149COMPREHENSIVE DANGEROUS DRUGS ACT OF 2002 - USE OF DANGEROUS DRUGS - RA 9165 Article II Section 15
41INDUCING A MINOR TO ABANDON HIS HOME - RPC Art. 271COMPREHENSIVE LAW ON FIREARMS AND AMMUNITION - RA 10591 (covers RA 9516, RA 8294 and PD 1866)
42INTENTIONAL ABORTION - RPC Art. 256CUSTOMS MODERNIZATION AND TARIFF ACT (CMTA) - RA 10863
43INTRIGUING AGAINST HONOR - RPC Art. 364CYBERCRIME PREVENTION ACT OF 2012 - RA 10175
44KIDNAP FOR RANSOM - RPC Art. 267 as amended by RA 18 and RA 1084DAMAGE AND OBSTRUCTION TO MEANS OF COMMUNICATION - RPC Art. 330
45KIDNAPPING AND FAILURE TO RETURN A MINOR - RPC Art. 270DATA PRIVACY ACT OF 2012 - RA 10173
46KIDNAPPING AND SERIOUS ILLEGAL DETENTION - RPC Art. 267 as amended by RA 18 and RA 1084FOOD AND DRUG ADMINISTRATION ACT OF 2009 - RA 9711
47LIBEL - RPC Art. 353FURTHER AMENDING ARTICLES 38 AND 39 OF THE LABOR CODE BY MAKING ILLEGAL RECRUITMENT A CRIME OF ECONOMIC SABOTAGE AND PUNISHABLE WITH LIFE IMPRISONMENT. - PD 2018
48LIBEL MEANS BY WRITINGS OR SIMILAR MEANS - RPC Art. 355ILLEGAL COMMERCIAL IMPORTATION OF USED CLOTHING AND RAGS - RA 4653
49LIGHT COERCIONS - RPC Art. 287ILLEGAL FISHING / THE PHILIPPINE FISHERIES CODE OF 1998 - RA 8550 as amended by RA 10654
50LIGHT THREATS - RPC Art. 283ILLEGAL POSSESSION OF BLADED, POINTED OR BLUNT WEAPONS - BP 6
51MALICIOUS MISCHIEF - RPC Art. 327ILLEGAL POSSESSION, MANUFACTURE, ACQUISITION, OF FIREARMS, AMMUNITION OR EXPLOSIVES - PD 1866 as amended by RA 8294 and RA 9516
52MALVERSATION OF PUBLIC FUNDS OR PROPERTY; PRESUMPTION OF MALVERSATION. - RPC Art. 217LAND TRANSPORTATION AND TRAFFIC CODE (COMPULSARY REGISTRATION OF MOTOR VEHICLES) - RPC Art. 4136 as amended by BP Blg 74
53OCCUPATION OF REAL PROPERTY OR USURPATION OF REAL RIGHTS IN PROPERTY - RPC Art. 312MALICIOUS DISSEMINATION OF FALSE INFORMATION OF THE WILLFUL MAKING OF ANY THREAT CONCERNING BOMBS, EXPLOSIVES OR ANY SIMILAR DEVICE OR MEANS OF DESTRUCTION AND IMPOSING PENALTIES THEREFOR. - PD 1727
54OTHER DECEITS - RPC Art. 318MANDATORY REPORTING OF NOTIFIABLE DISEASES AND HEALTH EVENTS OF PUBLIC HEALTH CONCERN ACT - RA 11332
55OTHER FORMS OF ARSON - RPC Art. 321MOTORCYCLE HELMET ACT OF 2009 - RA 10054
56OTHER FORMS OF SWINDLING - RPC Art. 316 as amended by PD 1689OMNIBUS ELECTION CODE OF THE PHILIPPINES - BP 881
57OTHER FORMS OF TRESPASS - RPC Art. 281PENALIZING OBSTRUCTION OF APPREHENSION AND PROSECUTION OF CRIMINAL OFFENDERS. - PD 1829
58OTHER FRAUDS - RPC Art. 214PENALIZING THE USE OR POSSESSION OR THE UNAUTHORIZED SALE TO MINORS OF VOLATILE SUBSTANCES FOR THE PURPOSE OF INDUCING INTOXICATION OR IN ANY MANNER CHANGING, DISTORTING OR DISTURBING THE AUDITORY, VISUAL OR MENTAL PROCESS - PD 1619
59OTHER LIGHT THREATS - RPC Art. 285PEOPLE'S SMALL-SCALE MINING ACT OF 1991 - RA 7076
60OTHER SIMILAR COERCIONS - RPC Art. 288PHILIPPINE FISHERIES CODE - RA 10654
61POSSESSION OF PICKLOCKS OR SIMILAR TOOLS - RPC Art. 304PHILIPPINE MINING ACT OF 1995 - RA 7942
62QUALIFIED SEDUCTION - RPC Art. 337PHILIPPINE PASSPORT ACT OF 1996 - RA 8239
63QUALIFIED SEXUAL ASSAULT - RPC Art 266-BPRICE ACT - RA 7581
64QUALIFIED TRESPASS TO DWELLING - RPC Art. 280PROVIDING FOR THE ESTABLISHMENT OF SMOKE-FREE ENVIRONMENTS IN PUBLIC AND ENCLOSED PLACES - EO 26 in relation to RA 8749 and RA 9211
65REBELLION OR INSURRECTION - RPC Art. 134QUARANTINE ACT OF 2004 - RA 9271
66RESISTANCE AND DISOBEDIENCE TO A PERSON IN AUTHORITY OR THE AGENTS OF SUCH PERSON - RPC Art. 151REVISED FORESTRY CODE OF THE PHILIPPINES - PD 705
67SEARCHING DOMICILE WITHOUT WITNESSES - RPC Art. 130SAFE SPACES ACT (GENDER BASED SEXUAL HARASSMENT) - RA 11313
68SEXUAL ASSAULT - RPC Art 266-ASEXUAL HARRASSMENT ACT OF 1995 - RA 7877
69SIMPLE SEDUCTION - RPC Art. 338SPECIAL PROTECTION OF CHILDREN AGAINST CHILD ABUSE, EXPLOITATION AND DISCRIMINATION ACT. (ANTI- CHILD ABUSE LAW) - RA 7610
70SLANDER (ORAL DEFAMATION) - RPC Art. 358TARIFF AND CUSTOMS LAWS (ANTI-SMUGGLING) - PD 1464
71SLANDER BY DEED - RPC Art. 359THE CONSUMER ACT OF THE PHILIPPINES - RA 7394
72SLIGHT ILLEGAL DETENTION - RPC Art. 268THE FORESTRY REFORM CODE OF THE PHILIPPINES (ILLEGAL LOGGING) - PD 705
73SPECIAL CASES OF MALICIOUS MISCHIEF - RPC Art. 329THE HUMAN SECURITY ACT OF 2007 - RA 9372
74SWINDLING (ESTAFA) - RPC Art. 315 as amended by PD 1689THE INTELLECTUAL PROPERTY CODE OF THE PHILIPPINES (THE COPYRIGHT LAW). - RA 8293
75SWINDLING A MINOR - RPC Art. 317THE MEAT INSPECTION CODE OF THE PHILIPPINES - RA 9296
76TUMULTS AND OTHER DISTURBANCE OF PUBLIC ORDERS; TUMULTUOUS DISTURBANCE OR INTERRUPTION LIABLE TO CAUSE DISTURBANCE - RPC Art. 153THE PHILIPPINE DENTAL ACT OF 2007 - RA 9484
77UNINTENTIONAL ABORTION - RPC Art. 257THE SECURITIES REGULATION CODE - RA 8799
78UNJUST VEXATIONS - RPC Art. 287TOBACCO REGULATION ACT OF 2003 - RA 9211
79UNLAWFUL ARREST - RPC Art. 269VIOLATION OF MAGNA CARTA FOR DISABLED PERSON - RA 7277 AS AMENDED BY ra 9442
80USING FICTITIOUS NAME AND CONCEALING TRUE NAME - RPC Art. 178WILDLIFE RESOURCES CONSERVATION AND PROTECTION ACT - RA 9147
81USURPATION OF AUTHORITY OR OFFICIAL FUNCTIONS - RPC Art. 177THE ANTI-SQUATTING LAW REPEAL ACT OF 1997 - RA 8368
82VIOLATION OF DOMICILE - RPC Art. 128URBAN DEVELOPMENT AND HOUSING ACT OF 1992 - RA 7279
83IMMORAL DOCTRINES, OBSCENE PUBLICATIONS AND EXHIBITIONS AND INDECENT SHOWS - RPC Art. 201 as amended by PD 960 and PD 969PENALIZING THE UNAUTHORIZED INSTALLATION OF WATER, ELECTRICAL OR TELEPHONE CONNECTIONS, THE USE OF TAMPERED WATER OR ELECTRICAL METERS, AND OTHER ACTS - PD 401
84ANTI-MONEY LAUNDERING ACT OF 2001 - RA 9160 as amended by RA 9194 and RA 10365ANTI-BULLYING ACT OF 2013 - RA 10627
85CONNIVING WITH OR CONSENTING TO EVASION - RPC Art. 223JUVENILE JUSTICE AND WELFARE ACT OF 2006 - RA 9344
86COUNTERFEITING, IMPORTING AND UTTERING INSTRUMENTS NOT PAYABLE TO BEARER - RPC Art. 167EXPANDED ANTI-TRAFFICKING IN PERSONS ACT OF 2012 - RA 10364
87ABANDONMENT OF PERSON IN DANGER AND ABANDONMENT OF ONE'S OWN VICTIM - RPC Art. 275
88MALICIOUS DELAY IN THE ADMINISTRATION OF JUSTICE - RPC Art. 207
89ADMINISTERING INJURIOUS SUBSTANCES OR BEVERAGES - RPC Art. 264
90MALTREATMENT OF PRISONERS - RPC Art. 235
91INCRIMINATING INNOCENT PERSON - RPC Art. 363
92EVASION OF SERVICE OF SENTENCE - RPC Art. 157
93INCITING TO WAR OR GIVING MOTIVES FOR REPRISALS - RPC Art. 118
94USING FORGED SIGNATURE OR COUNTERFEIT SEAL OR STAMP - RPC Art. 162
95ATTEMPTED AND FRUSTRATED ROBBERY COMMITTED UNDER CERTAIN CIRCUMSTANCES (HOMICIDE COMMITTED) - RPC Art. 297
96ARBITRARY DETENTION - RPC Art. 124
97ABUSES AGAINST CHASTITY; PENALTIES - RPC Art. 245
98ALTERING BOUNDARIES OR LANDMARKS - RPC Art. 313
99VAGRANTS AND PROSTITUTES - RPC Art 202
Source



Hopefully someone can help me. Thank you.
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Forum statistics

Threads
1,214,583
Messages
6,120,378
Members
448,955
Latest member
BatCoder

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