Hi guys,
Was working on this issue for last 6 months, not being able to crack the code... To manage this file, the way it's set up, it basically takes 1 day a month to complete updates, which, it feels, is a day of life wasted every month. Wondering if your smart brain would be able to suggest a better solution?
I am attaching a file here:
https://www.excelforum.com/attachmen...1&d=1506769829 [EXCEL]
An issue in details:
FILE PURPOSE:
1. Monthly tabs = entire system, with categories and tasks + end of month report
2. Daily tabs = each task is broken down into particular time of a day
ACTION PROCESS:
1. At end of each day go into a Daily tab (on Mon go to Mon tab, On Tue go to Tue tab, etc) , and state 'y' or 'no' to mark if a task was completed
2. Review Monthly tab at the end of a month, to see how you performed in a particular category, and a performance of that particular month
CHALLENGE:
Each cell in a Monthly tab needs to be manually connected to cells in Daily tabs (please view a file attached, to see how its done). This process currently takes tremendous amount of work, every single month!
WORK-AROUND?
Based on details provided in a file, would it not be possible to set it in some way so that Monthly tab generates results based on a:
1. month selected (cell AF1 in Monthly tab)
2. day of the week that a month starts (row 3 on Monthly tab)
I don't know if I'm making it clear, or what other details to provide. But if you take a look at a file, and witness the amount of work it currently takes to update each newly added Monthly tab, you will see exactly what is described here.
Any suggestion for a better workaround this issue, would be greatly appreciated! Thanking you...
Bookmarks