Macro to amend formulas

Hello out there

Would anyone be able show me how to run a macro that would go into a cell, add the ROUND function to it, and move down to the next cell so that I could run the macro again on a different formula?

Example: my formula currently looks like this:

=IF(ISNA(VLOOKUP("0707750900",Data!$A$2:$I$65001,2,FALSE)/1000)=TRUE,0,VLOOKUP("0707750900",Data!$A$2:$I$65001,2,FALSE)/1000)

I want it to look like this:
=ROUND(IF(ISNA(VLOOKUP("0707750900",Data!$A$2:$I$65001,2,FALSE)/1000)=TRUE,0,VLOOKUP("0707750900",Data!$A$2:$I$65001,2,FALSE)/1000),1)

I will need to do this amendment hundreds of times. I tried to record a macro, run through the keystrokes, then stop recording. When I go to add the ROUND function to the next cell, it copies the exact formula from before.

Any help is appreciated.

Thanks
Wayne

Please Login or Register  to view this content.