Is there an easier way?

Debaser · #1 06-19-2018, 02:47 AM

If you need to do this while using Excel online too, VBA will not be an option. A slightly easier manual option would be to filter one column by each colour in turn, then populate all visible cells with the relevant values. Repeat for each column.

Hankced · #2 06-19-2018, 05:19 AM

Quote:

Originally Posted by Debaser

If you need to do this while using Excel online too, VBA will not be an option. A slightly easier manual option would be to filter one column by each colour in turn, then populate all visible cells with the relevant values. Repeat for each column.

Say what? Y'know I don't wanna be annoying by being such a noob, but this seems to be an even simpler solution than coding. Thanks to all btw

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Help making invoices easier	wbowles	Office	0	07-17-2013 10:39 AM
Please help me with an easier solution!	Inquisitor	Word	1	06-26-2011 01:01 AM
Easier highlighting?	atarei	Word	0	08-27-2010 05:28 PM
Microsoft Word Easier Navigation Question	xxlegendxx	Word	0	03-22-2009 07:44 PM