I want to create a spread sheet that starts with two names column a and b.
then c thru n i want to enter numbers 1-55 in the order i take them of the sheet.
then i want to put the numbers in a thru ??? in numerical order.
once a week i want to be able to enter any 5 numbers between 1 and 55 and have the nunbers be hightlighted. some weeks the numbers may over lap.
so week one could be 1, 5,9,23,52, week 2 might be 1,7,18,24,52
this will repeat until one or more rows have all been highlighted.
Where should i start? is excel the right program?
Peace
Chong
Bookmarks