Another VBA Question

[weefatbob]

Morning all

I am looking for VBA to enable me to search my spreadsheet where the 'Grade' column is equal to 'APP'

I have the autofilter as Sub check3() Range("A:1:X1").Autofilter6,"=APP"

I know I may not need this, but want to leave it in, to let users see it has worked. What I am looking to do is

If Grade =APP then Supervisor ID = "Value 1", Supervisor Forename = "Value 2" Supervisor Surname = "Value 3" Supervisor mail - "Value 4" and Supervisor Dept = "Value 5"

Hope this make sense.

 

[vcoolio]

You're welcome Weefatbob.

Cheerio,
vcoolio.