One way...

For your dropdown list in A1, use data validation. Select List in the the
Allow box and enter the 3 options in the Source box: Loans, Cards, Ebanking

Somewhere in your workbook (maybe on another sheet, which you can hide),
create 3 named ranges with names that exactly match the options in A1. For
example, enter Retail in a cell and Corporate in the cell below it. Select
both cells and name that range Loans. Create a Cards named range and an
Ebanking named range the same way.

On starting sheet, in B1, select Validation from the Data menu. Select List
from the Allow box, and in the Source box enter: =INDIRECT($A$1)

Now B1 will list the values in the named range selected in A1. Hope this
helps,

Hutch

" wrote:

HI,

I would like link cells with macro in Excel (if this is good
descriptions):
In cell A1, I have list od three options. Dependensy I choose some
option from the list, than in B1 I must have correct list.

Example,
in A1 I have list (validation cell) of three options (loans, cards, e-
banking)
When I choose options loans from validation cell list, than in B1 will
show validation list with two option (Retail, Corporate).

When I choose options cards from validation cell list, than in B1
will show validation list with two option (VISA, MASTER).

When I choose options e-banking from validation cell list, than in B1
will show validation list with two option (Retail e-banking, Corporate
e-banking).

If someone know, thanks

Srdjan R.