I have an existing Excel spreadsheet that I need help with "hooking up" six columns to lookup tables. Each column has its own lookup data table on separate worksheets.
**Please see [login to view URL] in the attached zip file for this project.**
In the end result, I will want to be able to copy each dropdown to any number of rows that I might have in the spreadsheet. The spreadsheet only contains ten rows of sample data right now. But will hold hundreds later.
## Deliverables
Spreadsheet contains (6) columns that need to use a dropdown select list to enter data.
Each column has its own lookup data in a worksheet.
Geography column = Geography worksheet
ProgramsParent column = ProgramsParent worksheet
ProgramsChild column = ProgramsChild worksheet
Date column = Dates worksheet
Religion column = Religions worksheet
Theme column = Themes worksheet
Two of the columns have a parent / child relationship. These are, ProgramsParent and ProgramsChild. Please see worksheets for more info.
When a user edits the data in this spreadsheet, I would like each column to be a dropdown select list, that gets its data from its respective worksheet.