Hi,
I have a workbook called "Approved Sub-Contractor Database.xlsx". In that work book is a basic excel database with the following headings and lots of records:
In a separate workbook, on my 'Labour Only' sheet, I want a drop down list that is automatically pre-populated with all of the Sub-Contractor names in the database for Labour Only sub-contractors.
Then, when one of those sub-contractors is selected, I want various cells in the sheet to automatically populate based on the corresponding record of the selection. So if 'Subbie' was selected in the dropdown list, then Contact, Address Line 1, Address Line 2, Address Line 3 etc would be filled in on the new work sheet based on the data from the database.
Hopefully I've explained that well enough and someone can assist?
All help would be welcomed.
Many Thanks
I have a workbook called "Approved Sub-Contractor Database.xlsx". In that work book is a basic excel database with the following headings and lots of records:
In a separate workbook, on my 'Labour Only' sheet, I want a drop down list that is automatically pre-populated with all of the Sub-Contractor names in the database for Labour Only sub-contractors.
Then, when one of those sub-contractors is selected, I want various cells in the sheet to automatically populate based on the corresponding record of the selection. So if 'Subbie' was selected in the dropdown list, then Contact, Address Line 1, Address Line 2, Address Line 3 etc would be filled in on the new work sheet based on the data from the database.
Hopefully I've explained that well enough and someone can assist?
All help would be welcomed.
Many Thanks