Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combobox.value reference
Hi people,
Summary: 4 worksheets sheet 1 = 2 comboboxes sheet 2 = list of people sheet 3 = list of projects sheet 4 = summary of people and their projects Combobox1 = list of the staff surnames (Column C - Sheet 2) Combobox2 = list of projects (Column C - Sheet 3) I am trying to write some code that will take the value selected from combobox1 and select the row of data (Column B:F) where that value came from in sheet 2 and paste it into A1 of sheet 4 and the same for combobox2 but for projects and to paste it after the staff details in sheet 4 (Example sheet4: staff details A : D, project details E : H) Thanks again for your help |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How To Reference What Is In A ComboBox In A Cell Formulas??? | Excel Worksheet Functions | |||
How do I copy a combobox to many cells with relative reference? | Excel Discussion (Misc queries) | |||
Dynamic ComboBox Reference | Excel Programming | |||
Reference A Combobox On The First page. | Excel Programming | |||
Add a combobox to an Excel spreadsheet and reference value in VBA | Excel Programming |