Being somewhat new to VBA for Excel, I am trying to get this formula to auto copy down my column:
I have searched all sorts of information and get it close but can't figure out the syntax issue I continue to have in my formula. It works perfect in Excel. But when I put it into my VBA code I get errors. I tried changing " to ' and no luck around my if statement values. Can someone tell me the best way to copy this down via code?
Basically, when a user imports a new record, I want it to look in cell I3 and copy it down column I so the user no longer has to copy or auto fill it down manually. Tried many things but just can't get the syntax aligned properly it seems.