I am fairly new to using Excel for database type stuff. I am trying to get data validation to create a drop down menu from the items on a sorted list. I will try to explain:
I have a list of all my Projects from 2010 in one column, and in the next column they are either listed as active or completed.
On another worksheet I have a timesheet with a column to designate the project and then seven columns to designate each day of the week. I want the Project column to have pulldown lists where I would just see "active" projects from my original project list. I can only figure out how to get it to show all the projects. Is there a way to do this? I just spend 3.5 hours trying to figure this out with no luck.
Thanks,
Louisa
I have a list of all my Projects from 2010 in one column, and in the next column they are either listed as active or completed.
On another worksheet I have a timesheet with a column to designate the project and then seven columns to designate each day of the week. I want the Project column to have pulldown lists where I would just see "active" projects from my original project list. I can only figure out how to get it to show all the projects. Is there a way to do this? I just spend 3.5 hours trying to figure this out with no luck.
Thanks,
Louisa