VBA Help to Check if Column B is Available on Column C Vice Versa

[rickjason]

I have this 3 Colums to Check if the Value is available on Column B and C

On Column B Employees Name Header is Availabe on Column C Employee's Name Header however on a different column
On Column B Manager Name Header(On Different Column) is Available on Column Managers Name Column

This part of the that I am downloading everyday, I want to automate it however I am new to VBA, Thanks for the help
Expected Value will on Column A and all rows with FALSE value to delete the row

	A	B	C
1		Employee's Name	Manager Name
2	TRUE <tbody> </tbody>	Kobe Bryant <tbody> </tbody>	Terrence Romeo <tbody> </tbody>
3	FALSE <tbody> </tbody>	Larry Bird <tbody> </tbody>	James Yap <tbody> </tbody>
4	FALSE <tbody> </tbody>	Dennis Rodman <tbody> </tbody>	Mark Caguioa <tbody> </tbody>
5	TRUE <tbody> </tbody>	Shaquille O'neal <tbody> </tbody>	Mark Caguioa <tbody> </tbody>
6	FALSE <tbody> </tbody>	Allen Iverson <tbody> </tbody>	Jayjay Helterbrand <tbody> </tbody>
7	TRUE <tbody> </tbody>	Dirk Nowitzki <tbody> </tbody>	Keifer Ravena <tbody> </tbody>
8	FALSE <tbody> </tbody>	Charles Barkley <tbody> </tbody>	Larry Fonacier <tbody> </tbody>
9	TRUE <tbody> </tbody>	Manu Ginobili <tbody> </tbody>	John Arigo <tbody> </tbody>
10	TRUE <tbody> </tbody>	LeBron James <tbody> </tbody>	Joseph Yeo <tbody> </tbody>
11	FALSE <tbody> </tbody>	Kevin Durant <tbody> </tbody>	Joseph Yeo <tbody> </tbody>
12
13		Manager Name <tbody> </tbody>	Employee's Name <tbody> </tbody>
14	FALSE <tbody> </tbody>	Arwind Santos <tbody> </tbody>	Reggie Miller <tbody> </tbody>
15	FALSE <tbody> </tbody>	Bo Belga <tbody> </tbody>	Draymond Green <tbody> </tbody>
16	TRUE <tbody> </tbody>	Mark Caguioa <tbody> </tbody>	Shaquille O'neal <tbody> </tbody>
17	FALSE <tbody> </tbody>	Vince Hizon <tbody> </tbody>	Stephen Curry <tbody> </tbody>
18	TRUE <tbody> </tbody>	Joseph Yeo <tbody> </tbody>	LeBron James <tbody> </tbody>
19	TRUE <tbody> </tbody>	Terrence Romeo <tbody> </tbody>	Kobe Bryant <tbody> </tbody>
20	FALSE <tbody> </tbody>	Allan Caidic <tbody> </tbody>	Russell Westbrook <tbody> </tbody>
21	TRUE <tbody> </tbody>	Keifer Ravena <tbody> </tbody>	Dirk Nowitzki <tbody> </tbody>
22	FALSE <tbody> </tbody>	Calvin Abueva <tbody> </tbody>	Giannis Antetokounmpo <tbody> </tbody>
23	FALSE <tbody> </tbody>	Mike Cortez <tbody> </tbody>	Kyrie Irving <tbody> </tbody>

<tbody>
</tbody>

 

[rickjason]

Hi All,

No need to answer this inquiry, I already Figure it out. Thanks.