Hi,
I wondered if you could assist me.
I am entering data in a cell.... if I make that cell colour Blue (or any colour of my choice), I would like whatever information is in that cell to be copied to a different worksheet and cell.
I am not sure if this is possible without some VBA code because for each cell that has had its colour changed to blue, it would to copy to another worksheet but to the next consecutive cell so it does not overwrite.
Any help would be much appreciated!
Thanks in advance.
Bookmarks