Hi all,

I need help to delete 12 (P:AB) columns on my data.

D10 = Key in range

P4:AB500 = data table
P=company name

First i need vba to help me find the D10 value first.

Second to delete entire row (P:AB) which company name match with D10.

Thank you.