Hi,

I have set up a user form with two drop downs one for the persons name and
the other for the current month. What I want it to do is when they select
their name it will filter through Column C and just show the information
relating to them and if its not in this Column to then filter through Column
D (this is because there is a primary and secondary delegate in case of
abscence). With the month this looks at Column B as they have to look at
certain bits at certain times and i would also like this filtered. Here is an
example of how it looks.

Month Of
Review Primary person Secondary person
July Charles Stewart-Jenssen Richard Anderson

How can I achieve this?

Regards