First post and very green when in comes to Macros.

I have a spreadsheet with multiple columns. Column 4 is Tenant Name and Column 6 is a Notes field.

If column 6 says "Vacant" I want the Vacant to show in Column 4.

After putting "Vacant" in column 4 I want to delete columns 6,7 and 8.

Any help would be greatly appreciated.

Thanks,
Barry