AUtomatic fill of cells

[verfre]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I am looking for a way to fill multiple cells with just adding data to one single cell.
p.ex. When I fill in the name of a person, the adres should be filled in automaticly in the next cells. Those adresses should, of course be aviable in another sheet.

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I am looking for a way to fill multiple cells with just adding data to
one single cell.
p.ex. When I fill in the name of a person, the adres should be filled in
automaticly in the next cells. Those adresses should, of course be aviable in
another sheet.

To do so will require using a formula. You can pre fill the area to contain
the addresses with the formula. Look in Help for Hlookup, it should do what
you want. If you want to do it completely automatically without entering
formulas, then you will have to use a macro.