![]() |
Macro to access data in an array?
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 |
All times are GMT +1. The time now is 09:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com