I have a spreadsheet with 10 different columns. Column A has the key information in it I need to save the file under several different file names. For example, in column A I have this:

A
Red
Yellow
Blue
Green
Purple
White

I want to filter on each color, and save a file under its name. For example, I want to filter on Red, save the file and call it "Red" and then filter on Yellow and save a file called "Yellow". Is this achievable with Excel in some sort of automated process or is this more of an Access function? I have a lot of colors in the column and it would be most cumbersome to go through and do it manually. Thank you.