Hi Glenn,
I remember you from last time and you were very helpful!
Ok, Ive got a colum called 'Suppliers' and each of the cells below the column are either coloured, 'Blue' or 'Red'. There are a list of different suppliers listed under this column heading, and the ones that are highlighted blue are 'Non-Contracted' and the ones that are highlighted 'Red' are 'Contracted' suppliers. Say for eg, i wish to filter the Red.....
Now, having done a search on this board, someone suggested that i look at this link:
http://www.cpearson.com/excel/SortByColor.htm
Now im not an expert with VB, but ive managed to copy and paste the formulae into a new VB window. Ive got as far as this paragraph on the page:
"Of course, change the reference A1 to the first cell in the range. Use Edit, Fill, Down to fill this formula down to the entire range of data you want to sort."
It's saying that that in these cells, i'll see numbers between 1 and 56, but i dont know what he's going on about? Plus, how do i sort out the Colour Index?
Your help is appreciated once again!
Thanking you!
GG