Because of the way the sheet is set up to collect much data they just put an
"x" in the cell for their selection. I could change the layout and use data
validation.

"Gary''s Student" wrote:

Let's say the reference cell is Z100 and the choices are F39, F40, and F41.

I allow the user to make a choise by use data validation in Z100 to pick one
of the three choices.

In your application, how is the user chosing??
--
Gary''s Student - gsnu200907


"Kesbutler" wrote:

I need the other cell to automatically populate with the user's choice. That
data is used in some auto calculations else where in the workbook. I'm not
seeing that ability using validation. Am i missing it?

"Gary''s Student" wrote:

In the other cell, place a Data Validation pull-down that references F39 thru
F41
--
Gary''s Student - gsnu200907