I am trying to write a program in Excel if possible, I want to be able to type information in cell A1 and have

Question

I want to be able to type information in cell A1 and have cells B1, C1, D1, auto fill in the other information for me. A better example is: John Doe is type by me in A1 field the other fields designated for his street address, city, and state appear in the other fields.

Answer 1

You would need to use formulas to references the cells. Here are some tutorials that could help you:
http://www.fgcu.edu/support/office2000/excel/

http://www.wcu.edu/ccenter%5Finf/CatOnline/MSEX/

http://www.mrexcel.com/articles.shtml#Formulas

Answer 2

You need to have a sheet with all the data on and in a second sheet enter vlookups into cells B1, C1 etc using A1 as the cell to search for =VLOOKUP(A1,Sheet1!A:E,2,FALSE) where 2 is the column to be returned so C1 will be 3, D1 4 and so on if all the data is in the same order.