Ok let me see if i can explane this correcting.
In my job i need to do a daily reports for ever construction project I am working on that day. In the report i have to fill in all the subcontractor on the job that day and what they did (tasks). This can become ever time consuming as each trade has it own list of work preformed.
I have created a daily reportwork book called DailyReport and a second workbook called DailyReportDBase that I store my subcontractors and there work performed. I have figured out how to use a data validation list from a different workbook, that works fine for some of the simpler fill in cells. what I am looking to do is a dependent drop down list but the lists are stored in the DailyReportDBase workbook and to make it more fun i want a separate worksheet for each subcontractor with there list of work performed.
In my job i need to do a daily reports for ever construction project I am working on that day. In the report i have to fill in all the subcontractor on the job that day and what they did (tasks). This can become ever time consuming as each trade has it own list of work preformed.
I have created a daily reportwork book called DailyReport and a second workbook called DailyReportDBase that I store my subcontractors and there work performed. I have figured out how to use a data validation list from a different workbook, that works fine for some of the simpler fill in cells. what I am looking to do is a dependent drop down list but the lists are stored in the DailyReportDBase workbook and to make it more fun i want a separate worksheet for each subcontractor with there list of work performed.