Hi all,
I need to learn some more advanced Excel techniques.
To start with, I am wondering if this is possible:
I have highlighted various cells a particular colour in an excel worksheet.
Is it possible to automatically copy all the coloured cells and paste them together either on the same worksheet or another? So if I changed the colour of a cell it would automatically be added to a list elsewhere.
I am also open to other suggestions for achieving the same effect.
Cheers.
Bookmarks