I have a list of projects in rows B2:B22, below this range at B24:B54 Is a listing a staff personnel assigned to the team. Each person has 4 rows below their name to assign them to a project. I use the validation list method to only choose the projects in rows B2:B22 to populate their assignments. In column C, I have the projects assigned to an area, (also based on a validation list). What I would like to do is use multiple activex combo boxes to filter the worksheet based on my combo box selections. I have included a screen shot to help in visualizing my goal.
file:///C:/Documents and Settings/maywj1/My Documents/screen shot.jpg
file:///C:/Documents and Settings/maywj1/My Documents/screen shot.jpg
Last edited:
