Pasting multiple rows based on index number

Hi,

I have rather simple question (for you).

Example below. In sheet "check" I have my index numbers and months for each number. In "data" sheet I have well... data. I would like to paste all rows from data sheet into new sheets based on index/month from check data. So at the end I would like to have 5 new sheets filled with data from specific month.

Problem1: Index numbers are not unique. There are numbers which exists in 2+ months.
Problem2: I have some ideas, altho my knowledge is very limited, so I'm looking for efficient macro. I have lots data to process.

I was thinking about putting data into access table, and then just running 5 queries, but I guess this also wouldnt be best. From time to time I need to add index numbers, so changing criteria for queries would be painful.

Thanks in advance.

Hi kwagam,
try this

Please Login or Register  to view this content.

Works great... now I only need to spend xx hours to understand how this works.

Thank you for fast answer.