lodhnerist
New Member
- Joined
- May 3, 2020
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
Hi. I have created a dailywise progress report of a project using conditional formatting. The project is of approx 6 months duration. The project being a lengthy one, it is not possible to print the whole progress in a single page. For that purpose, I have created a dynamic calendar showing 12 months at a time upto the year 2049 in the next worksheet. Now I am unable to use any formula across these two worksheet. My aim was that the calculations in the first sheet will be displayed in the calendar of 2nd sheet as colour fill. The first month and year of the calendar should be automatically selected from the start date of project, so that the total progress can be be shown in single page itself. How can I create a database for such multiple projects?
Kindly help.
Kindly help.
