One way to try, save your workbook first.
To do it manually ~ I am assuming your data starts in row 6.
First do this ~
copy this formula
=OFFSET($E$5,1,0,COUNTA(OFFSET($A$5,1,0,9999)),62)
In the formulas menu, click name manager, Click new, in the name box type in green for the name. in the refers to box paste the formula you copied. Click OK
Now you need a header row above your data, then you would select that header row and Click Auto Filter in the data menu.
Next step is to filter in column A by colour, you would click the triangle and select filter by colour, select the green.
Next press Alt and G, type in green, then copy (the area automatically selected), then select your destination you wish to paste to, select Paste Special, Values, OK.
If you wish to retain formulas and formats instead of values, just click Paste instead of Paste Special.
Would be easier to do it with a macro. If you wish a macro more details would be needed.
e.g. Sheet names, data range, cell to copy to and colour index of the green you wish to filter.
Cheers
