Hello,

I am new to excel and new to this forum. I am currently trying to move data from a Master worksheet, called "Master". In the "Master Worksheet, all the data will be sorted by cell colors (Yellow, Green, Blue, Red and White(or no color)). I need this data to be sorted into separate a separate worksheet for each of the colors. Is there a way to do this in excel with formulas? or do I need to use VBA? And how would I do this?

Thanks!