Array in workbook

[paulmtl]

Hi all,

I am very new to VBA and Excel workbook, someone told me to use an array would be very advantage instead of using macro.

Please give me some advices and tips to start with an array.

TIA

 

[fredericofonseca]

dim variable .....

But you still need a macro.

What are you trying to achieve?

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[bclt]

What exactly are you trying to do ?
Help me to help you

 

[paulmtl]

Hi Frederico Fonseca,

I would like to achieve the input cells from one sheet to other sheets for example :

sheet 1 has :
cell1 to fill in from sheet2 that contains acctnum# as primary key with custname,address,tel . like in the combobox refers as arrays to be built.

When the user picks the selected acctnum# by double click on will copy all informations to cell1 in sheet1 directly.

Hope this clarify my request.
Thanks again for your help.

 

[bclt]

Err...

 

[fredericofonseca]

I think a little more detail is required, along with some data.

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[paulmtl]

Hi Frederico Fonseca,

Here is the first sheet1 need to be fill from sheet2 and sheet3 in the same workbook.

sheet1:
Bulk Issue Name Coupon Mat Date
1 FORD CREDIT CDA
2
3
4

sheet2 :

ISSUE_NAME COUPON MAT_DATE
FORD CREDIT CDA 5.96 3-Dec-35
GM US CIE 6.05 27-Jul-09

SHEET3:
ACCOUNT NAME COUPON MAT_DATE
11111 FORD CREDIT CDA 5.96 12/03/2035
22222 GM US CIE 6.05 07/27/2009

My design is to use the button ADD in sheet1 to get the values from sheet2 and sheet3 :

Issue name

Coupon

Maturity

Account number from sheet3

and I don't know how the put the informations both from
sheet2 and sheet3 into a single array combined and selected
from there with the ADD button process

sub ADD()
...
...
endsub

Actually, sheet1 was blank and need to be fill manually with ADD(), but sheet2 and sheet3 were pre-downloaded directly from another system.

Thanks in advance,
Paul

 

[earthandfire]

Try VLOOKUP

Hope this helps.

 

[bclt]

VLOOKUP has as arguments tables ! Define also some tables