moving cell values to another cell in XL

  conrail 11:23 08 Mar 12

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 12

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 12

ps. incase of misunderstanding:

don't type the : just type the =C2

  conrail 13:56 08 Mar 12

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

  Woolwell 14:35 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 28 May 12

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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

iPad Pro 12.9 vs Surface Pro 5