Otispunkmeyer
New Member
- Joined
- Oct 2, 2006
- Messages
- 8
I have alot of data from a plate levelling machine
plate name, width, lenght, gauge, yield data, roll mode, overstretch and strategy used
there are 5 worksheets in this book 1 = levelled plates in 1 pass, 2 = levelled plates in 2 passes etc
firstly i would like to know how to sort the data with regards to plate dimensions
ie.... i need an operation/program that will go through the width and length columns and group all like plates together (so 4000x2000 plates get grouped and highlighted in yellow, the 10000x3000 get grouped and highlighted in green)
is this easy to do? i have limited knowledge of excel and VB but i tend to learn fast.
plate name, width, lenght, gauge, yield data, roll mode, overstretch and strategy used
there are 5 worksheets in this book 1 = levelled plates in 1 pass, 2 = levelled plates in 2 passes etc
firstly i would like to know how to sort the data with regards to plate dimensions
ie.... i need an operation/program that will go through the width and length columns and group all like plates together (so 4000x2000 plates get grouped and highlighted in yellow, the 10000x3000 get grouped and highlighted in green)
is this easy to do? i have limited knowledge of excel and VB but i tend to learn fast.