Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro summarizing count below an array of data | Excel Discussion (Misc queries) | |||
Copying Data from Access to Excel in a macro | Excel Worksheet Functions | |||
Looking for Macro to load data from Access table | New Users to Excel | |||
Need Excel macro for exporting data to Access | Excel Programming | |||
Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) |