Programming or Function?

J

jweasl

I have a large list of items - what I would like is when someone enters the
item code, the rest of the information (description, etc) fills in. I know I
can do this with AutoComplete - just wondering if there is a better way since
I am using a large list and don't want to type in each item description by
hand.
 
J

jweasl

Hi Gord!
I'm pretty familiar with Vlookup and Data Validation - I already use that in
another instance - but my issue here is I want to type in a cell and then
have the same cell's contents change. Looks like I need a Loop function, and
I have no experience with those :-(
 
G

Gord Dibben

You mean you want the code you typed in to be overwritten by the description?

Sounds a little dangerous to me.

How do you account for errors in typing?

You could use event code using Case Select I suppose but with many item codes
that could become quite lengthy.

One of the VBA guru's will come up with something loopy, I'm sure.


Gord
 
J

jweasl

This is a one-time use kind of thing, but great for future learning for
myself. There are no typos, I'm sure of that :-D
 
D

Debra Dalgleish

There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You could adapt this to your
workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "DV0005 - Data Validation Columns"
 
G

Gord Dibben

Thanks for getting me off the hook Debra<g>

Beats the heck out of a gaggle of Case Selects.


Gord

There's a sample workbook on my web site that shows a product name and
code in the Data Validation dropdown list. After an item is selected,
the cell shows only the product name. You could adapt this to your
workbook.

On the following page:

http://www.contextures.com/excelfiles.html

Under Data Validation, look for "DV0005 - Data Validation Columns"
Click to expand...

Gord Dibben MS Excel MVP
 
Top