moving cell values to another cell in XL

  conrail 11:23 AM 08 Mar 12
Locked
Answered

using windows 7 64 bit with office XP, I run a local football team and keep the fixtures, scores & scorers list on XL, I would like to create a cell that shows if we have played team A and won 3-1 (the 3 is in one cell and the one in another, ie cell c5 = 3 and cell c6 = 1, the next time we play team A I would like to show the previous score of 3-1 in another cell ie K2 hope that is clear, all help and advice appreciated.

  lotvic 13:37 PM 08 Mar 12
Answer

select K2 and type: =C2 and press enter

select K3 and type: =C3 and press enter

(or could just select K2 and type: = then put mouse cursor in C2 and click and then press enter)

  lotvic 13:40 PM 08 Mar 12

ps. incase of misunderstanding:

don't type the : just type the =C2

  conrail 13:56 PM 08 Mar 12

thanks lotvik, that's what I was after, I appreciate your help, many thanks

  Woolwell 14:35 PM 08 Mar 12

If you want to ensure that the reference to the original cell remains as C2 then you can use =$C$2 . Absolute References

  conrail 16:20 PM 28 May 12

thanks Woolwell, really sorry about the delay in replying, been a busy couple of months, I appreciate your time and advice

Advertisement

This thread is now locked and can not be replied to.

How to watch EA Gamescom 2015 Press Conference live: EA Gamescom live stream - watch EA talk Star…

1995-2015: How technology has changed the world in 20 years

Play the retro 8-bit dating naked adventure game by The Uprising Creative

From Antennagate to Yellowgate: The 10 worst Apple scandals (and why they were blown out of proport)…