Copying formulas to differnet columns

[christal]

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

 

[Al Chara]

If all your columns are together, then highlight all your data and then copy and paste it one column to the right. This will offset the formulas by one column. This will not affect the second occurrence of columns because they are aboslute referenced with $.

 

[christal]

Sorry I didn't specify earlier, but my columns ar NOT all together... I think that's my problem!!

Any resolution to my predicament!!??

Thanks

 

[Gary_E]

Try editreplace again, but instead of replacing S with R | Replace =S with =R should make it a distinct replace

 

[christal]

Great idea.. I'm sure it will work!!

Thanks!