Sorting + Macros

[xirokx]

Hi,

Please help me resolve my 2 excel 2003 related queries:

1) How do you sort by colour ? I have noted seperated info by colour but how can I sort by colour?

2) Macros - I would like to add a button on the actual spreadsheet which I believe is a macro that:

a) when i click it sorts by colour
b) when i click the second button sorts by ref

Please help?

Thanks in advance