Copying formulas to differnet columns

christal · Apr 16th, 2002, 12:40 PM

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 · Apr 16th, 2002, 12:50 PM

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 · Apr 16th, 2002, 12:53 PM

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 · Apr 16th, 2002, 01:09 PM

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

christal · Apr 16th, 2002, 01:39 PM

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

Thanks!

Apr 16th, 2002, 12:50 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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 $. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 12:40 PM	#1
christal New Member Join Date: Apr 2002 Posts: 45	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

Apr 16th, 2002, 12:53 PM	#3
christal New Member Join Date: Apr 2002 Posts: 45	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

Apr 16th, 2002, 01:09 PM	#4
Gary_E Board Regular Join Date: Feb 2002 Location: Charlotte, NC USA Posts: 108	Try editreplace again, but instead of replacing S with R \| Replace =S with =R should make it a distinct replace

Apr 16th, 2002, 01:39 PM	#5
christal New Member Join Date: Apr 2002 Posts: 45	Great idea.. I'm sure it will work!! Thanks!