moving cell values to another cell in XL

  conrail 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 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 08 Mar 12

ps. incase of misunderstanding:

don't type the : just type the =C2

  conrail 08 Mar 12

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

  Woolwell 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 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.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

Encore creates eerie effects for Spielberg's new TV show The Whispers

How to set up Apple Music & make sure you don't get charged: Get Apple Music for free

We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message