+ Reply to Thread
Results 1 to 2 of 2

Help with making references dynamic based on cell value with a find and replace

  1. #1
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Help with making references dynamic based on cell value with a find and replace

    Spreadsheet attached.

    This is just an example of what I'm working with. I have a lot more rows. What I need is the following. In column D, I would like to do a search replace so that all of the AL references will take the value in O7 and all the AM references will take the value in 08. Ideally I would like to do a find and replace to insert the formula (I have tons of rows).

    I want to do the same thing for column E and F, linking them to P7 and P8 and Q7 and Q8.

    One important note: I just want ot make the columns reference those cells, the rows need to stay hard coded.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,404

    Re: Help with making references dynamic based on cell value with a find and replace

    Hi,

    Does using wildcards in Find/Replace cause other problems?
    I may be misunderstanding the problem, but I think that selecting column D, then entering 'AL*:' into the 'Find' box and 'O7:' into the 'Replace' box should work? Using the ':' in each box should prevent accidental replacing of other 'AL' instances. Or you could use 'AL???:' but then you might need to do 'AL????:' as well, if your rows go into the thousands.

    Sorry to waste your time if you've already tried this.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find and Replace - locking cell references
    By Terri Earley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2014, 12:09 PM
  2. Find/Replace with references
    By DFrank231 in forum Excel General
    Replies: 2
    Last Post: 08-16-2012, 04:47 PM
  3. Using Find & Replace to edit cell references in links
    By Matt7102 in forum Excel General
    Replies: 0
    Last Post: 03-15-2006, 04:55 PM
  4. Replies: 0
    Last Post: 10-13-2005, 02:05 PM
  5. cannot find any references to replace
    By Kelli in forum Excel General
    Replies: 4
    Last Post: 02-09-2005, 08:23 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1