Join our investing community

Excel....help, please

Discussion in 'Off Topic' started by Jayar, 3rd May, 2007.

  1. Jayar

    Jayar Well-Known Member

    Joined:
    15th Aug, 2005
    Posts:
    130
    Good morning,
    Can someone please help me with a small Excel problem. For example, I have a Worksheet1 with an amount in B4 that I manually update.
    Would like to have this value automatically update on Worksheet2 in cell c6, and perhaps Worksheet3 in cell G12.
    And if, in a similar way, I wanted to have a formula transferred to other sheets/cells in the same way, how would I do that?
    (My worksheets have different names to worksheet1, worksheet2 etc.)
    Thanks for any help
    Cheers
    Jayar
     
  2. Rickson

    Rickson Well-Known Member

    Joined:
    23rd Oct, 2005
    Posts:
    52
    In the cell that you want to change, simply click in the cell, type = and then click in the cell in the other sheet with the value.

    This works the same whether the cells are in the same worksheet, in another worksheet, or in another spreadsheet file (so long as you don't change the name of the spreadsheet or the location.
     
  3. Chris.R_WA

    Chris.R_WA Well-Known Member

    Joined:
    7th Aug, 2006
    Posts:
    113
    Location:
    Perth, WA
    Hi Jayar,

    Try this: In Worksheet2 C6 (where you want to info to update), type in "=Worksheet1!B4"
    This will automatically update Worksheet 2 C6 with the data entered in the first Worksheet.

    Note: If you change the name of the worksheets, eg January, February etc... the formula changes to "=January!B4".

    Not too sure about the formula, maybe just copy and paste, and check the reference cells in the formula.

    Regards, Chris
     
  4. Jayar

    Jayar Well-Known Member

    Joined:
    15th Aug, 2005
    Posts:
    130
    Thanks, Chris and Rickson,
    Will give it a try when I get home from work.
    Much appreciated
    Jayar
     
  5. DaveJ

    DaveJ Well-Known Member

    Joined:
    13th Nov, 2005
    Posts:
    123
    You can use the 'Paste Special' selection

    Steps:

    1. Select the cell you want as the 'master reference'
    2. Select Copy or 'CTRL+C' as a shortcut
    3. Go to the cell you want to put the link in
    4. Right click on the cell and select the 'Paste Special' selection
    5. Use the 'Copy Link' selection


    It will do the same as typing what was mentioned earlier... Just just don't have to remember the syntax this way! :rolleyes:
     
  6. Jayar

    Jayar Well-Known Member

    Joined:
    15th Aug, 2005
    Posts:
    130
    DaveJ,
    Works a treat :D
    Thanks for that.
    Jayar