Delete row if value A matches any column B?

[Carradee]

I'm trying to figure out how--if it's even possible--to set up a VBA program to compare two columns in two separate sheets. (I'll call them Sheet1_ColumnA and Sheet2_ColumnB.)

If a value in Sheet2_ColumnB matches any value in Sheet1_ColumnA, I want to delete the row involved with that value in Sheet2_ColumnB.

Any idea how I'd do this?

I think I might be able to figure it out if anyone can point me to how to compare any value between two columns.

Thanks!

[VBA Noob]

Post a sample file and I'll take a look

VBA Noob