Since the OP doesn't seem that familiar with Excel comboboxes, this describes
the Dropdown/Combobox from the Forms toolbar (rather then the Control Toolbox
Toolbar).

--
Regards,
Tom Ogilvy


"AKphidelt" wrote:

Well you can try this. Set up the combo box, right click it and go to Format
Control. Where it says Input Range, highlight the employee names or create a
named range for the employees names.

In the Cell Link, put this next to the employees list. This cell will tell
you what item has been chosen out of the combo box.

Using this Cell Link number you can now use Offset/Vlookup/Match, etc
formulas to come up with the individual employees information.

Let me know if you have any more questions.

"Loni - RWT" wrote:

When it comes to combo boxes and coding and whatever else is supposed to be
going on, I know nothing about it. So pardon me if I don't sound very
intelligent. Here's what I want to do: I have a workbook with multiple
input sheets and one report sheet where all my data is being calculated. On
my report sheet, I want to put a combo box to choose different employees.
Based on the selection that is chosen, I then want it to pull certain
information from one of the various input sheets. I went to the control
toolbox and inserted a combo box. Now What????
I have tried to figure out how to put names to select from in the combo box,
but nothing seems to work. I've read thru several of the threads here, but I
haven't seen anything that I think particularly helps me out. Can anyone
give me any insight?
Thanks!!