SpiffyMasta
Thread Starter
- Joined
- Aug 4, 2004
- Messages
- 117
Ok, so hopefully I will explain myself clearly enough that someone can help me out.
I have an excel workbook which is essentially a timesheet and has two sheets, one is "time sheet" and the other is "jobs".
The jobs sheet has information which is pulled from another excel file. This information includes 4 columns I use called company, department, friendly name, and quickbooks job. I've set up a dynamic name range which automatically includes new data in some lists I've created. One includes all the table's data, one list includes all the friendly name column data.
Currently, the time sheet is all setup and has a drop down list which pulls from my list named friendlyname. This works great at the moment, because there aren't that many different jobs.
I would like to make it easier in the long run for the user to find a specific job by choosing from two drop down list two items: the company and the department. Here the departments available would depend on what company is picked. From there the drop down list currently used to pick a job would only have the friendly name items which belong to that company and department.
I've done tons of research online, and I am completely stumped as to what I need to do.
Every job entry gets all the information needed on one row, including the company and department.
Hopefully someone can help!
Thanks
I have an excel workbook which is essentially a timesheet and has two sheets, one is "time sheet" and the other is "jobs".
The jobs sheet has information which is pulled from another excel file. This information includes 4 columns I use called company, department, friendly name, and quickbooks job. I've set up a dynamic name range which automatically includes new data in some lists I've created. One includes all the table's data, one list includes all the friendly name column data.
Currently, the time sheet is all setup and has a drop down list which pulls from my list named friendlyname. This works great at the moment, because there aren't that many different jobs.
I would like to make it easier in the long run for the user to find a specific job by choosing from two drop down list two items: the company and the department. Here the departments available would depend on what company is picked. From there the drop down list currently used to pick a job would only have the friendly name items which belong to that company and department.
I've done tons of research online, and I am completely stumped as to what I need to do.
Every job entry gets all the information needed on one row, including the company and department.
Hopefully someone can help!
Thanks