Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Copying formulas to differnet columns

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  2. #2
    MrExcel MVP Al Chara's Avatar
    Join Date
    Feb 2002
    Location
    Newark, Delaware
    Posts
    1,701
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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 abo****e referenced with $.
    Best regards,
    Allan Chara
    http://www.mrspreadsheets.com

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Charlotte, NC USA
    Posts
    108
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  5. #5
    New Member
    Join Date
    Apr 2002
    Posts
    45
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    Thanks!

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •