
Calendar spreadsheet
- or -
Post a project like this1899
$42
- Posted:
- Proposals: 7
- Remote
- #3027899
- Awarded
TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting

277900626013771711586144943312644633873491649865
Description
Experience Level: Entry
Estimated project duration: 1 day or less
I have a spreadsheet that has multiple calendars on it.
They have event dates and has conditional formatting changing colors every time you add or change a date.
What I need is that every change in every sheet reflects automatically on the sheets SPORTING 2021 and SNT 2021
In this copy only the internal color/font color and border not the conditional formatting (This is important)
The range changes:
Example sheet:
MNT 2021 E5:AI5 (Month of January) this will copy internal color/font color and border to SPORTING 2021 E6:AI6 and SNT 2021 E6:AI6
MNT 2021 E6:AI6 (Month of February) this will copy internal color/font color and border to SPORTING 2021 E17:AI17 and SNT 2021 E8:AI8
And this consecutively until December
SPORTING 2021 will receive copies from cells color from following sheets:
MNT 2021, WNT 2021, YNT 2021, ENT 2021
SNT 2021 will receive copies from cells color from following sheets:
MNT 2021, WNT 2021
Note that YNT 2021 and ENT 2021 have more that one line, I need that all lines be copied (colors) to destination sheets.
I have provided some code example, but I had trouble to repeat this to other lines and sheets.
Can be at selection the code update.
They have event dates and has conditional formatting changing colors every time you add or change a date.
What I need is that every change in every sheet reflects automatically on the sheets SPORTING 2021 and SNT 2021
In this copy only the internal color/font color and border not the conditional formatting (This is important)
The range changes:
Example sheet:
MNT 2021 E5:AI5 (Month of January) this will copy internal color/font color and border to SPORTING 2021 E6:AI6 and SNT 2021 E6:AI6
MNT 2021 E6:AI6 (Month of February) this will copy internal color/font color and border to SPORTING 2021 E17:AI17 and SNT 2021 E8:AI8
And this consecutively until December
SPORTING 2021 will receive copies from cells color from following sheets:
MNT 2021, WNT 2021, YNT 2021, ENT 2021
SNT 2021 will receive copies from cells color from following sheets:
MNT 2021, WNT 2021
Note that YNT 2021 and ENT 2021 have more that one line, I need that all lines be copied (colors) to destination sheets.
I have provided some code example, but I had trouble to repeat this to other lines and sheets.
Can be at selection the code update.
LUCIANO K.
100% (2)Projects Completed
1
Freelancers worked with
1
Projects awarded
50%
Last project
28 Oct 2020
Brazil
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-

Good day, I have sent a proposal with a DEMO vba script to update the 2 primary calendars when making changes to your first two input lists. Do take a look and let me know if you want me to finish up that piece of work.
950810
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies