Simple one for most on here but any help will be greatly appreciated.

I need a macro that will look at a range (AX5:AX2000), if a cell in that range = 1 then it will delete the corresponding cell on that row in columns Q:S.

Thanks in advance!