I'm trying to get a macro to copy rows in column A to new sheets based
on the value in row A. I really could use some help! Thanks so much.


For example

original sheet has the values:

Column A, Column B
Red, 123
Red, 234
Red, 111
Blue, 124
Blue, 453
Yellow, 234
Yellow, 531
Yellow, 123

.... and the macro makes three new sheets:

New sheet1:
Column A, Column B
Red, 123
Red, 234
Red, 111

New sheet2:
Column A, Column B
Blue, 124
Blue, 453

New sheet3:
Column A, Column B
Yellow, 234
Yellow, 531
Yellow, 123