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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Watch MrExcel Video

Forum statistics

Threads
1,119,284
Messages
5,577,200
Members
412,776
Latest member
nadroy87
Top