C
chemdude77
Hi, I'm trying to make a macro that will:
1. Take a matrix of data stored on a worksheet and load it into an array.
The matrix will look like this:
Blue Red White Green
jetta 3 1 5 0
bug 2 1 6 1
explorer 5 4 3 1
fusion 0 0 3 0
2. Then in the working sheet will be the types of cars in separate cells
(single row): jetta bug explorer fusion
3. After the user selects the cells containing the cars, the macro should
ask for an output cell and then search the array and printout the colors of
cars starting with the highest numbers and going in decending order, with the
zero value colors being printed out in alphabetical order at the end Example
with the data above:
Jetta Bug Explorer Fusion
White White Blue White
Blue Blue Red Blue
Red Green White Green
Green Red Green Red
I am a newb and any help as to how I can get started with this would be
extrememly helpful.
Matt
1. Take a matrix of data stored on a worksheet and load it into an array.
The matrix will look like this:
Blue Red White Green
jetta 3 1 5 0
bug 2 1 6 1
explorer 5 4 3 1
fusion 0 0 3 0
2. Then in the working sheet will be the types of cars in separate cells
(single row): jetta bug explorer fusion
3. After the user selects the cells containing the cars, the macro should
ask for an output cell and then search the array and printout the colors of
cars starting with the highest numbers and going in decending order, with the
zero value colors being printed out in alphabetical order at the end Example
with the data above:
Jetta Bug Explorer Fusion
White White Blue White
Blue Blue Red Blue
Red Green White Green
Green Red Green Red
I am a newb and any help as to how I can get started with this would be
extrememly helpful.
Matt