moving cell values to another cell in XL

  conrail 11:23 08 Mar 2012
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 08 Mar 2012
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 08 Mar 2012

ps. incase of misunderstanding:

don't type the : just type the =C2

  conrail 13:56 08 Mar 2012

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

  Woolwell 14:35 08 Mar 2012

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 28 May 2012

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

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?