Hi Guys,
I am trying to make a time sheet for work, I have a big table full of a number of project codes in one column, and then in an adjacent column a number of tasks with all fall within the same project code.
I have managed to sort the project codes into a unique list and then input this into a drop down list, and now I am trying to do something similar with the task codes. So when the project code is selected in the first drop down list, it will auto populate a second drop down list with the corresponding task codes for that project.
The thing that I am trying to do, is to do this without having to have the second drop down list be populated from a secondary table, I would like it all to come from the main table (Hope that makes sense).
So the question really is, is there anyway to populate a drop down list using a function which will search the entire table and populate its self based off the value already in one cell, without having to have a "helper" column?
Many thanks,
Gareth
Bookmarks