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.

UK's best mobile network 2016: best 3G, best 4G, best mobile networks revealed

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

Adobe Animate replaces Flash Pro

23 tips & tricks for Mac OS X El Capitan: The best, coolest and least well-known new features in OS1…