transfering by macro

[asoom]

i have a table in sheet1 that has phone number address and home town i want to use macro, that when i write the phone number in cellA in sheet2

The other information transfer to cellB, C atuomaticly

just when i write the phone number in cellA The other details which is address and home town appers.

[Armando Montes]

Try vlookup.

[asoom]

but can i do this with macro? my profeser want me to do this step by macro

[asoom]