I am working on a project using 2 xls files,
xls 1 used by maintenance and contains macro, hidden worksheet (data for drop down list) and a form.
xls 2 hold list of all properties.
In xls 1, I have 2 drop box inspector and properties. The inspector drop box is populated from the hidden worksheet, i have 3 columns that holds 10 inspector names:-
C1 C2 C3
Name Job Title Area/region
Inspector 1 Position 1 NEYH
Inspector 2 Position 2 MEE
...etc
in xls 2, locked master property data, updated on a regular basis, containing 8 columns:
LL name, LL email, property code, address1, address2, post code, status, area/region
problem:
In xls 1, when the inspector selects his/her name from the drop down list (setup to show only C1 data), how do i identify value in C3 and then use it to examine xls 2 to populate the second (properties) drop down list in xls 1.
So that the second dropbox does not show all properties, only specific to his/her area/region.
Appreciate any pointer or guidance.
Bookmarks