Copy/paste cells from different sheets

Closed
Shearer - May 27, 2010 at 04:04 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 28, 2010 at 01:34 PM
Hello,
I am trying to create a diary using excel to keep track of everything. As I am a referee I want it to have all the games I have refereed on a different sheet.
For example when on the diary page a cell has the word "game" in it, I want that whole cell to be copied onto another sheet. I want it to do this for all of my games? It could also be if the cell if filled in a certain colour, which ever makes it work!
Can anyone help?


1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 27, 2010 at 04:43 PM
You meant "Whole Row" to be copied right ?

Could you please upload a sample file with sample data etc on some shared site like https://authentification.site , http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee.
0
http://wikisend.com/download/493476/Diary.xls
I want to copy a certain cell when it has been filled, for example, green
Or when it has a certain word in it. Just that cell and the info inside it.
Thanks
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 28, 2010 at 01:34 PM
I am sorry but I am still not able to understand. Based on you sample file could you explain more in detail how you want to copy and where etc
0