Hi

I have a slight programming problem that I would be greatful for some help with.

I have a spreadsheet that contains a set of data. It is about 60 columns wide and the number of rows are variable.

One column contains the grade of the product that has been manufactured that week. The grade is an integer value. I want to find a way to get a list of all the different grades that have been made that week, then find the data related to each instance of that grade and copy it to a new worksheet. This should leave me with a workbook giving me a sheet per grade.

Any help would be much appreciated

Cheers

Dave