Hi everyone,
I was hoping to get some help with a spreadsheet I have been trying to develop for work, have spent hours and hours watching videos and reading tutorials but can not get my formulas to work properly and am hoping its even possible.
In this particular sheet I am tracking opening and closing times for a number of different areas, these areas are in separate sheets labelled January, February, March etc and this is where the main source of data is, at the end of the column's is a total calculating the amount of hours it was open and then an average for the month.
What I was hoping to achieve was in the tab 'Performance Tracker', I have listed all the areas and then there are tables with Daily Target Hours, Total of Hours Open, YTD of Total Hours Open, Daily Average and YTD Daily Average and from there I wanted a drop down list with the relevant reporting month to show data from the particular month and the information change as you select different months in the Hours Open and the Daily Average Hours, I was hoping YTD would remain and there would be a separate formula simply adding up the total for the year.
It would also be beneficial if Daily Average Hours changed to red when below the target hours and green if it was above.
Im not sure if this is all possible or if I'm asking too much from Excel but any assistance would be greatly appreciated.
Thank you for any help.
SC
Bookmarks