Thanks Thanks:  0
Likes Likes:  0
Results 1 to 10 of 10

Thread: Make a cell display another cells value only

  1. #1
    Board Regular
    Join Date
    Jun 2011
    Location
    London, England
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Arrow Make a cell display another cells value only

    Hi all,

    I have some formulae in A1, is it possible for cell B1 to display the value only of A1 without the link to the formulae. I dont want to have to run a macro, or paste values, more of a formula that could be assigned to cell B1 so whenever A1 is changed, so is B1 automatically.

    Thanks,

    Pedro.

  2. #2
    Board Regular
    Join Date
    Mar 2011
    Location
    Solihull, UK
    Posts
    330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Quote Originally Posted by Pedro's PhD View Post
    Hi all,

    I have some formulae in A1, is it possible for cell B1 to display the value only of A1 without the link to the formulae. I dont want to have to run a macro, or paste values, more of a formula that could be assigned to cell B1 so whenever A1 is changed, so is B1 automatically.

    Thanks,

    Pedro.
    Maybe I've misunderstood but could you not just use (in B1)

    =A1

    ?
    Excel 2010 (64-bit)

  3. #3
    Board Regular
    Join Date
    Jul 2002
    Location
    Milton Keynes, England
    Posts
    11,044
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Explain the reason why you want this?
    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

  4. #4
    Board Regular
    Join Date
    Jun 2011
    Location
    London, England
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Hi Glenn,

    I have toned down my question for where it will be used, but the principle is the same. In the spreadsheet it will go in, the formula in A1 is 4 rows long in the formula bar, and it takes excel around 60s to calculate it.

    If i have it linked, when i click on B1 it says =A1, but then it takes another 60s to calculate it. I was hoping for something that when i clicked on B1 it just said the value of A1. Not sure if this is possible, or if there is a way you can format the cell to effectively have a paste values assigned to it?

    Thanks.

  5. #5
    Board Regular
    Join Date
    Jul 2002
    Location
    Milton Keynes, England
    Posts
    11,044
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    What do you mean it takes another 60 seconds to calculate? If the formula is already in cell B1 it will get calculated automatically when A1 calculates ( and not double up the calculation ).
    Cheers, Glenn.

    Beauty is in the eye of the beer-holder.

  6. #6
    Board Regular
    Join Date
    Jun 2011
    Location
    London, England
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Sorry, i have not been clear. The reason I wanted a cell with just the value in, is because I then copy that value into another workbook.

    You may suggest that I can link up that workbook, but that is not possible as i copy the values into different columns each time.

    So ultimately, when I copy and paste into the new workbook, it takes another 60s. This is why i was looking to see if pasting just the values with no formulae attached would speed things up. (Paste values does not solve this).

  7. #7
    New Member
    Join Date
    Jan 2014
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Hi Pedro, did you ever find an answer to this? I'm facing this issue now and would love to know if there is a simple solution not involving macros.

    Quote Originally Posted by Pedro's PhD View Post
    Sorry, i have not been clear. The reason I wanted a cell with just the value in, is because I then copy that value into another workbook.

    You may suggest that I can link up that workbook, but that is not possible as i copy the values into different columns each time.

    So ultimately, when I copy and paste into the new workbook, it takes another 60s. This is why i was looking to see if pasting just the values with no formulae attached would speed things up. (Paste values does not solve this).

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

    Default Re: Make a cell display another cells value only

    Even i am looking for the same solution. This is required when i need to copy only the values to another application & not the formula.

  9. #9
    Board Regular
    Join Date
    Jun 2011
    Location
    London, England
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Quote Originally Posted by excelnewb123123 View Post
    Hi Pedro, did you ever find an answer to this? I'm facing this issue now and would love to know if there is a simple solution not involving macros.
    Hey excelnewb123123, apologies for not replying sooner, I have only been alerted to your original question following the one from loke_r83 today. Unfortunately I never did find the solution to the problem.

    Sorry...... Pedro

  10. #10
    New Member
    Join Date
    Feb 2014
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Make a cell display another cells value only

    Hi Pedro,
    Have you tried this one? devilishly simple but you may have overlooked it?

    =VALUE(A1)

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
  •