Can I auto fill a cell in one worksheet by typing a code number

[Gomer Pyle]

I want to be able to autofill a cell by typing a number and having the next
cell autofilled with information from another worksheet.

 

[Dave Peterson]

Maybe =vlookup() or =index(match()) would be what you want.

You could look at Debra Dalgleish's site:
http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html