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