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 |
All times are GMT +1. The time now is 12:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com