+ Reply to Thread
Results 1 to 2 of 2

Extract Cell Reference from Formula Change Reference Column Populate new Cell

  1. #1
    Registered User
    Join Date
    12-08-2014
    Location
    South Dakota
    MS-Off Ver
    MS Office 365
    Posts
    50

    Extract Cell Reference from Formula Change Reference Column Populate new Cell

    I have the following formula in a cell:

    =E4-'L:\Sales\Market Pricing Revision-PDFs\[Market Pricing 2-1-15.xlsx]MASTER PAGE'!$E$74

    In the Cell next to it I want to extract the reference: 'L:\Sales\Market Pricing Revision-PDFs\[Market Pricing 2-1-15.xlsx]MASTER PAGE'!$E$74

    And change the column from E to I and use it to populate the cell. So the new cell (cell next to it) will be:

    ='L:\Sales\Market Pricing Revision-PDFs\[Market Pricing 2-1-15.xlsx]MASTER PAGE'!$I$74

    I want to be able to quickly replicate this function for a number of cells.



    Thanks in advance!
    Last edited by kellyjo7; 02-11-2015 at 12:14 PM.

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Extract Cell Reference from Formula Change Reference Column Populate new Cell

    b1=Right(A1,LEN(A1)-3)

    c1=Substitute(B1,82,1,"I")
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ 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. Dragging formula, change sheet reference, but not cell reference
    By Kalilaya0419 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-13-2013, 04:50 PM
  2. Replies: 7
    Last Post: 01-07-2013, 12:27 PM
  3. Replies: 2
    Last Post: 05-26-2009, 05:55 PM
  4. Replies: 7
    Last Post: 10-01-2006, 08:43 PM
  5. Change the width of a column by using a cell reference
    By None Specified in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2006, 05:00 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