I have a spreadsheet which is populated from microsoft forms and if the question isn't answered it returns a 0. I want to change that 0 to N/A without using a formula as there is a whole page filter formula on the worksheet. Can I use a VBA?
So this is looking up columns A:P and S on Form 1 and filtering to Abermad tabIf you post your formula I can show you how to do it.