Forum Discussion
trying to create daily work schedule baced on Cell Value
I have a work book that i have been working on and tinkering with and on it I have a sheet seen below and what i am trying to do is create a weekly schedule based on Column F of the sheet in first picture to the schedule sheet in second Picture. So what ever the start date is I would like for it to list each row based on the dated on schedule sheet. I would like for it to show the information in Colums B,G,I,J for each row
6 Replies
You don't necessarily have to invent something that already exists ... and even for free from Microsoft :))
Track your daily and weekly tasks easily using this interactive schedule template. Add events to the event scheduler tab, select the appropriate day on the daily schedule tab, and allow Excel to help manage your day. This is an accessible template.
Hope I could help you with this additional information.
Nikolino
I know that I don't know (Socrates)
- Nikolino,
I already use that for my personal use I need one to pull information from my crews and the jobs they associated with- What exactly do you want to accomplish?
Can you add a file (without sensitive data)?
Image does not always (mostly not) help to understand what exactly is needed.
Especially when an ignorant person like me deals with it :))
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
- You can use Conditional formatting to achieve this. Just need to find the start and end date, then compare the date on the date row with these values. It is not so hard. I have done similar applications before.
