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
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?
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?
Related:
- Copy/paste cells from different sheets
- Sheets right to left - Guide
- Copy paste e with accent - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Copy and paste fonts - Guide
- Based on the cell values in cells b77 - Excel Forum
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
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.
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.
May 28, 2010 at 04:59 AM
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
May 28, 2010 at 01:34 PM