VBA - Deleting rows using another list.

[gd6noob]

Hi everyone.

Just wanted to see if someone can help me code something which im unable to figure out.

I have a set of requirements

Each location has their own requirements. i.e. DOI3 only Tier 1 and the following shifts, then DYT6, Tier 1 and the following shifts.

HRRC Canada Shift Differential Tool.xlsb
	R	S
12	DOI3 - DS (Brampton, ON, CA)	DYT6- DS (Ottawa, ON, CA)
13	Tier 1	Tier 1
14	NA5C0120	NA5C0120
15	NB1C0120	NB1C0120
16	NF6C0120	NF6C0120
17	NH3C0120	NH3C0120
18	NK7C0120	NK7C0120
19	NL4C0120	NL4C0120
20	NN2C0120	NN2C0120
21	DG6C0500
22
23	DOI3 - DS (Brampton, ON, CA)	DYT6- DS (Ottawa, ON, CA)
24	Tier 3	Tier 3
25	AAAC	AAAC
26	NB1C0000	NK2C2330
27	NN2C0200	NL4C2330
28	NA5C0000	NA5C0240
29	NA5C0120	NB1C0240
Dashboard

If this layout above isnt ideal, it can be re-arranged.

The list that needs to be delete from is below

HRRC Canada Shift Differential Tool.xlsb
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Location Desc	Supervisor User ID	Supervisor Name	Emp Name	Emp User ID	Emp ID	Emp Class	Barcode Emp ID	Emp Type	Job Title	Job Code	Job Level	FT/PT	Last Hire Date	Shift Pattern	Shift Pattern Desc	Shift Differential	FCML Area	Standard Hours	Cost Center	Department Name	regulatory_region
2	DYT6- DS (Ottawa, ON, CA)											Tier 3			SB3C1300
3	DYT6- DS (Ottawa, ON, CA)											Tier 1			NB1C0120
4	DOI3 - DS (Brampton, ON, CA)											Tier 1			NB1C0120
5	DOI3 - DS (Brampton, ON, CA)											Tier 1			NB1C0120
QS Roster