Holidays on Month Sheets

[xjohnson]

Hello,

Is it possible to fill in the monthly calendar sheets from the Holidays! sheet?

Thank you very much for your help,
XJ

[davesexcel]

Checkit out,

Please Login or Register  to view this content.

[xjohnson]

Thank you Dave it works but can I request that the data starts at the line below the days?

Starting at rows 4,10,16,22,28,and 34 please.

[davesexcel]

Change to

Please Login or Register  to view this content.

[xjohnson]

I don't understand where to make the change sorry.

[davesexcel]

Right now I had it as
g.Offset(,1).Value=

I just wanted you to change it to
g.Offset(1).Value=

The original code has been edited now

[maras_mak]

Hi, in the 'Holidays' sheet, name the range 'A3: A20' as 'holidays_'.
In the 'January' sheet, select the range 'A3: N33' -> conditional formatting -> new rule = COUNTIF (holidays_; A3) -> fill color.
Repeat for the remaining months.
Regards.

[xjohnson]

Dave with the updated code I am getting compile error at End Sub

[jeffreybrown]

Hi Dave,

In your code post #2, the m is not defined as a variable.

@xjohnson,

Add End With right before End Sub

[davesexcel]

Hi, in the 'Holidays' sheet, name the range 'A3: A20' as 'holidays_'.
In the 'January' sheet, select the range 'A3: N33' -> conditional formatting -> new rule = COUNTIF (holidays_; A3) -> fill color.
Repeat for the remaining months.
Regards.

Nice one,
Here and in Texas it would be,

Please Login or Register  to view this content.

[xjohnson]

I appreciate all of the responses but the rules changes seem difficult to do for my abilities.

[davesexcel]

Here is your workbook back with the updated code, also January sheet has a sample that maras_mak was referring to.

[xjohnson]

I put the End With and it works great thanks Jeffrey.

There is one exception though. There is a day for next year's New Year Day that I would like in the end of the end of the December month. There may also be a few days there if we take more days for the Christmas break.

Can this be added?

Thank you

[xjohnson]

I like the change to highlight the day when there is activity thanks Dave and Maras.

Wow this is a great workbook so far. Hope others can benefit.

[xjohnson]

Hi everyone,

Thanks for help but is there a way to also request that December includes the extra days for January of 2019 from the Holidays sheet?

See new revision please.

Thank you,
XJ

[davesexcel]

Here you go,

Please Login or Register  to view this content.