G Guest Aug 26, 2005 #1 I want to be able to autofill a cell by typing a number and having the next cell autofilled with information from another worksheet.
I want to be able to autofill a cell by typing a number and having the next cell autofilled with information from another worksheet.
D Dave Peterson Aug 27, 2005 #2 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
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
