Loop and fetching info from different sheet

[Rewmer]

Good day

I am still very new to VBA and have just started to work with my own coding.

I am trying to create a custom calendar from data which I have already established. I have all the dates in one column and I need it to show in my calendar weekly layout. I am trying to use loop and offset to do this.

Please Login or Register  to view this content.

What it is supposed to do is fill the dates in my calendar sheet by starting under my first day of the week until the last day of the week then go down to the next row and fill the 2nd week and then loop through the rest of the month. For now I am just trying to get this to work before I move to the rest of the process. The first macro formats the layout for my calendar. The second is supposed to do the above.

Thanks in advance for any assistance

[jolivanes]

Attach a normal workbook with all columns and rows showing.

[Rewmer]

Hi, its all there you can just unhide the data sheet's columns. I hid it to make it easier as I will only be using that column. Or am I misunderstanding your request?

[Rewmer]

The first macro does the layout for the calendar. So it automatically adds the weekdays and set the columns. Do you want me to run it then save it like that then reupload it? Is that what you are refering to? If so, here it is.

[Rewmer]

Ok, I now managed the loop but its doing the same thing in every cell. Its supposed to progress like a calendar eg 1 Nisan 2 Nisan 3 Nisan etc.

Here is the code I have managed so far for the 2nd macro. There is only 2x macros.

Please Login or Register  to view this content.

[jolivanes]

Explain in a concise manner what you want to do.
I can't see this being it but then stranger things have happened.
Just a stab at it.

Please Login or Register  to view this content.

[Rewmer]

Well consider this as "strange" then lol

I tweeked the code a bit so the start date is 1 Nisan with this code:

Please Login or Register  to view this content.

What I need now is to be able to select year and month. This will be according to column Q for year and M for month. I need to be able to see eg the month of Nisan for 2021/2022 or others options in the above columns.

Thx for assistance!

[jolivanes]

Please don't quote needlessly.

If you needed to tweak the code as you mentioned then your workbook is different from your attachment.
But as long as you have your requested answer and it works to the way you want, that's the important thing.

In your last attachment, Column M is days, not months.
When you say that you need to see the month of Nisan, what does that mean?

[Rewmer]

Its the same. I just made i=45 to read i=14. I see its i15. Maybe I had a typo when doing it.

Thanks again.

[jolivanes]

#2 under Forum Guidelines in the Forum Rules:
Don't quote whole posts -- it's just clutter.*

I added some questions to Post #8 that you might have missed while submitting your Post #9.

[Rewmer]

Yes I did miss your questions.

Month = P
Year = Q

What I mean is that I need to be able to select the month and year according to above columns so that I end up with only one month's info in the calendar.

[Rewmer]

Oh yes, my sample only has one year but I have 10yrs info in my original file.

[jolivanes]

There are 29 "01 Nisan" entries (all the same) and 350+ 2021/2022 entries (all the same).
If you select one of them, what do you want to do then? Put "1 Nisan" into the CALENDAR sheet?
Or just all the Nisan values (1 Nisan to 29 Nisan) into the CALENDAR sheet?

[Rewmer]

On my original file I have 10yrs of info. I would like to see eg:

Nisan 2021/2022 or Zif 2024/2025 or Adar 2027/2028

I need there to be a choice, maybe dropdown or allow to enter choice in cell. I am going to use A2 for typing in the month and E2 for the year. Maybe those cells can be the source for what needs to be filtered?