I'm building a sheet for collecting data for a project. There will be customer info entered into some fields, option buttons to select one of a series and two or three groups of check boxes where up to 12 different items "could" be checked.

I would like to move the information selected to Column "A" on the summary sheet having only one blank line between items.

The problem I see is moving the check box information since each group can have only one or most of the items checked.

Any ideas?

Thanks,

Les

Hi,

Data Sheet - select the range A1:A12 - on menu - Insert | Name | Define -
type the name and ADD

Main Sheet - Seletc the cell where you want the drop down C7 as sample - on
menu - Data | Validation | select list and on the box "refers to" type =name.

on cell d7 use =vlookup(c7,DataSheet!a1:b12,2,0)



hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Les Linton" escreveu:


My workbook has a Main sheet and a Data sheet.

I have a range on the Data sheet A1 to B12.

Column A has a two digit ID number 11, 12, 13....

Column B has a first and last name Bob Jones, Jane Doe, Bill Smith....

I want to create a dropdown list on the main sheet where I select a
number from column A "12" and it places the name "Jane Doe" in another
cell on the main sheet. "D7"

If this is possible, I would like to add more fields to the range or
table and have those fields filled in on the main sheet.

Thanks,

Les




--
Les Linton