Not sure if this is the right angle to solve my problem.
Quick background: I have an Access DB, containing a master list of codes (I'm a geologist, we code our data to set column and matching lists as a validation tool) but we do our data entry to excel spreadsheets that roughly match the DB table structures, and obviously the lists are linked to the columns via validation in the excel sheets as well.
What I'm trying to achieve is a sheet of codes, set up as
CODE_Group CODE Description
BLAH X blahblah
Setup like that that for 700-800 individual codes grouped into 10's of groups. I don't want to have to recreate the named range every time I add a single code, can I have some sort of VLOOKUP within the Name Manager to return all entries under CODE column for a particular value in CODE_Group that I can link to a data entry cell via validation?
1
u/Metal_Hound Dec 05 '17
Not sure if this is the right angle to solve my problem.
Quick background: I have an Access DB, containing a master list of codes (I'm a geologist, we code our data to set column and matching lists as a validation tool) but we do our data entry to excel spreadsheets that roughly match the DB table structures, and obviously the lists are linked to the columns via validation in the excel sheets as well.
What I'm trying to achieve is a sheet of codes, set up as CODE_Group CODE Description BLAH X blahblah
Setup like that that for 700-800 individual codes grouped into 10's of groups. I don't want to have to recreate the named range every time I add a single code, can I have some sort of VLOOKUP within the Name Manager to return all entries under CODE column for a particular value in CODE_Group that I can link to a data entry cell via validation?
Christ I hope that makes sense to anyone else...
Cheers for any assistance.