I am trying to replace the first column address from "S" to "R". I have tried the "Find and replace" function, but this will replace All the column addresses, which I don't want to do.... I need to change ALOT of columns of data, just like this. Got any ideas??
THis is the current formula:
=S18-[BlahInvAFH0104Adj0201.xls]Sched51!$S21
This is what it it should be:
=R18-[BlahInvAFH0104Adj0201.xls]Sched51!$S21
Thanks
THis is the current formula:
=S18-[BlahInvAFH0104Adj0201.xls]Sched51!$S21
This is what it it should be:
=R18-[BlahInvAFH0104Adj0201.xls]Sched51!$S21
Thanks