Automatically search for certain entries and copy them to certain places

[HerbertW]

Hello,

thanks for such an awesome board!
I have the following problem and hopefully you can help me to solve it via VBA. I have a list of different tasks which have to be done on different days all over the year.
So there a table 2 with all the tasks and the month and day it has to be done (january = 1, feb. = 2, ... and a second column with "day two, day 4,...").
I havbe a table 1 as well. At this tabel you see the whole Month, like a calender.

Is it possible to automatically sort and copy the entries from table 2 to table 1?

I already can copy only certain entries (for example, only entries for january), but how can I copy them to the right day of the week?

Please Login or Register  to view this content.

So how can I do it? I know i need a "If .Cells().Value = ..." same as the day i want it copy to, then copy. But I can't figure out how to do it for all days and and take the ones i need and how to copy them to the right place /day of the month.

Because the whole task is a little bit confusing, I added an example file!

I hope you can help me, thank you very mich!
Cheers

[HerbertW]

Sorry for the second post, but I thought about it tonight (again) and I could solve the first part of my problem with a function (in a new table)
=WENN(.....)

But I would prefere vba, because then I can add more tasks without changing/writing any functions.

[HerbertW]

Any chance, anybody can help me?