Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro summarizing count below an array of data Raj Excel Discussion (Misc queries) 1 November 28th 06 05:32 PM
Copying Data from Access to Excel in a macro GLS Excel Worksheet Functions 2 November 15th 06 03:47 PM
Looking for Macro to load data from Access table Randy K New Users to Excel 1 February 25th 06 12:30 PM
Need Excel macro for exporting data to Access halfshoe Excel Programming 4 January 18th 05 06:53 PM
Export Excel Data to Access With a Macro!!! Jac Excel Discussion (Misc queries) 3 December 28th 04 07:39 PM


All times are GMT +1. The time now is 11:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"