# Calendar Dynamic Color Cell - VBA

• royUK I know that I ask too much. Can the above question Calendar Dynamic Color Cell - VBA be done?

And, can we have the sum of each month? The totals are

 ΣΥΝΟΛΑ 1 0 0 0 0

from table tab. B1, C1,D1,F1 (separate not the sum of them) , but the total to be under the month at the calendar per month. If I made it clear.

Difficult ?

Thank you, you saved me

• royUK Thank you for your reply.

What I'd like to do is the when the new tab (the one that made under the today()) is filled (ranges B3:E5 & B10:E12) and change tab color from yellow to red, also the same date (today()) of the calendar to be also red (not yellow) in order to understand that that day is completed. My English are not that good, excuse me...

The second part of my question, is that I need the sum of every month of the calendar for B15, C15, D15 and F15 (something like the total of every month). I searched and I can use the ie SUM(Firstsheert:lastsheet!B15) but I cant make it work fom the current month (the current one). As you see from the picture at Calendar Dynamic Color Cell - VBA post. That part will be at table tab.

I really hope you understand ...

• So it must be difficult . Thanks for your time. If you can give me a hint what to do, because I am not good with excel, let me know.

Thank you royUK !!!

• I think that I didnt tell the problem correct.

Can I sum specific cell at the table sheet for the end of every month? I need at the last day to sum the all the totals from all the days of the current month.

Can you help?

Thank you!

• royUK what do you mean?

Every month at one sheer? or all the totals at one sheet ?

• royUK thank you (again) for your reply

You can see at the file attached what I mean about the total.

At sheet 26-06-2021 you can see some cell colored in RED

These are the totals of that day.

I want to sum the total of every day of the month (monthly sum) and display it at the Calendar sheet when I choose that Month (ie June for now)

At sheet calendar you can see where I need to put the monthly sum (yellow)

I really hope that was clear!

CalendarCAFEv2.xlsm

• Hi again

I have found this vba in inernet , it sum Monthly and Yearly , but not from collecting data from workrksheets but from one sheet.

Can this be modified for my case?

Or can I use sumproduct or sumifs? and not use vba?

Thank you in advance!

• Your project is getting more complicated because it is poorly designed. If I realised what you were doing I would have suggested a totally different approach.

As I said earleier the data should be on one sheet then it would be simple to build reports.

• Good morning,

Yes you are absolutely right. Unfortunately, at my company all the users asks for something else, and additions. That's why sometimes I really trying to catch up with them.

What the other approach will be?

If you can, help me to be better excel person ..

I am not a master in excel (you are) but I am trying to do my best and keep searching all the time.

Really thank you so much royUK

• if the data should be at one sheet or a totally different excel I don't care, as long as it works.

You see I, as I am trying to catch users, my colleagues need also a login / logout form to know when a user enters and leaves excel, users from a another excel or sheet. So need this just to check when someone enters excel to do changes ( to track who or did what). They said that this will be the last change... I know that I asks TOO MUCH but as you can understand you are my only hope. I really appreciate all the help and effort royUK , I promise I will not bother you again ...

So the final structure will be

1) Login form (as described above)

2) Calendar to make day choice (ok that, thank you)

3) Sum for all days of a month for specific cells (per month)

4) Logout

too much huh?

• The running totals or new sheet or under calendar, it doesn't matter really, as long they are there.

I just found it and post it.

• I've used an little Excel trick.

To make it work I have added two sheets named Top and Bottom. These are hidden and are not used except for the Running Total formula.

=SUM(TOP:BOTTOM!B15)

The above formula is used in the running total. It adds the same cell's value in every sheet positioned between the two new sheets.

I've added to the code so that the new sheets will be positioned correctly.

• Thank you royUK !

Will this sum all the days of a month (for each cell ie B15, C15, D15, E15, F15) ? I need the sum (monthly).

Will this continue to add forever (all months in total) or it will change calculation when month change?

But yes, it is wonderful as it is, very clever I have to say

About the login? Can I use cell protection or not working with various users? Or I need a login form to track login?

Thank you!

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!