View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Laus Laus is offline
external usenet poster
 
Posts: 6
Default Auto populate cells

Thanks much Gord. I'll go check Debra's site. As of now, I have the data
built into a list and if I click "form",it's all sorted correctly. I'll let
you know how it works out.

"Gord Dibben" wrote:

Laus

Data Validation for the drop-downs and VLOOKUP for the filling-in part.

See Debra Dalgleish's site for more on VLOOKUP and Data
Validation lists for entering the choices.

http://www.contextures.on.ca/xlFunctions02.html

http://www.contextures.on.ca/xlDataVal01.html


Gord Dibben MS Excel MVP

On Sat, 2 Dec 2006 15:06:00 -0800, Laus wrote:

Can a selection from a drop down menu trigger cosistent info to be input to
cells in the same row?


Gord Dibben MS Excel MVP