Copy/paste cells from different sheets

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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