Forum Discussion
Automatically change daily view gantt chart into weekly view gantt chart in Excel 2019
It has been solved by combining the weekday and eomonth functions.
Regards,
Sony
If I may suggest, please add a file (without sensitive data) and describe your plan on it.
The error could be identified faster and more specifically.
Please no picture, even if it is said that a picture is worth a thousand words, it is definitely not in the case of Excel.
This means that you can be helped more quickly and the best possible solution tailored to your needs can be offered.
So everyone is helped.
Help to be helped.
* It's always good to add your operating system and Excel version.
Thank you for your understanding and patience.
Nikolino
I know I don't know anything (Socrates)
Hi Niko,
Thank you for the advice.
This is an example I can give. Hopefully, it's clear enough.
thanks.
Regards,
Sony
Quickly, here is a file from the Internet with weekly division, maybe you will find in these suggestions for your.
Unfortunately, cannot help at the moment, as other commitments call.
But I am almost certain that someone will contact you.PS. The third-party products that this article discusses are manufactured by companies that are independent of me. I makes no warranty, implied or otherwise, about the performance or reliability of these products.
File is from:
https://www.vertex42.com/ExcelTemplates/gantt-chart-template-pro.html
Thank you for your understanding and patience.
Nikolino
I know I don't know anything (Socrates)
- Hello N.. I saw your excel sheet.. was helpful. Would you be able to guide me on how to put that scroll bar to run d weeks as it's shown on your file. Thanks in advance
How would I add a scroll bar into this macro in exel with the use of VBA microsoft
You will find instructions on how to add a scrollbar to your workbook. create yourself
Overview of forms, Form controls, and ActiveX controls on a worksheet
Important: This feature isn’t available in Office on a Windows RT PC.
Want to see what version of Office you're using?
More informations in the upper Links.
Also included an example file where you could do your tests yourself.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.