link data worksheets using drop down box

[brymc81]

I have a master sheet that serves as a master task list between committees, and there are separate worksheets for each committee.
The master task list has a drop down list which (should) assign that row of data to its corresponding committee worksheet.

The data also needs to update between the worksheets, e.g. when a task is marked complete on the committee worksheet, the master task list will also reflect the update.
It would also be nice for new data entered into a committee worksheet will appear on the master task list with the appropriate drop down value chosen.

This seems like simple programming, am I over/under thinking this?

[jaslake]

Hi brymc81

Looking at your Workbook/Worksheets I'd think you need to add a separate "Status" column to each worksheet and create the cross reference referred to below to accomplish this

when a task is marked complete on the committee worksheet, the master task list will also reflect the update

To do this

It would also be nice for new data entered into a committee worksheet will appear on the master task list

there'd need to be a cross reference between the Committee worksheets and the Master. At this point I don't see one. What's the "DUN" field?