Trouble with loop

Hello All!

I'm having some issues with a project I'm working on. I want to generate a report based on user selected criteria (done in a UserForm) and copy the rows of data that meet the criteria to a different worksheet. Here is my code so far.

Please Login or Register  to view this content.

Essentially, there are 3 potential sets of criteria. The first is the year and will always be included. The second two may not always be there based on the users preference. They are Month and a random assortment of other misc data such as name. The user picks these criteria in a userform and once they click 'create report' the UF dumps these selections into the spreadsheet. Therefore the report can have 4 possible outcomes:

1: A (Just the Year)
2: A & B (Year and a Month)
3: A & C (Year and name)
4: A, B & C (Year, Month and Name)

While in case A the code row must have a matching Year in order to be true, in the others that row must then have a matching B and/or C in order to be true and be copied into the other worksheet. I hope I'm making this all clear.

When I ran the code it just kept going and going, but didn't produce any data. Any Ideas?

Thanks

I did some more research and reworked the above macro into this....

Please Login or Register  to view this content.

But it still doesn't work. Any Ideas?

Well I figured just about everything out with this issue, however I still have one problem. I'm trying to offset the activecell by using a variable since I don't know how much I need to offset by everytime. Here is my code.

Please Login or Register  to view this content.

Can anyone help?