lodhnerist

New Member
Joined
May 3, 2020
Messages
1
Office Version
  1. 2013
Platform
  1. 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.
 

Attachments

  • Untitled1-min.jpg
    Untitled1-min.jpg
    85 KB · Views: 5
  • Untitled2-min.jpg
    Untitled2-min.jpg
    71.7 KB · Views: 5

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Watch MrExcel Video

Forum statistics

Threads
1,118,852
Messages
5,574,660
Members
412,608
Latest member
Guromir
Top