My name is Jason I am new to this forum and had no where else to turn for some help.
Ok guys, I have run into a serious road block with an excel document. Heres what I am trying to do, bare with me!
Example, and I can post the excel document if anyone needs to see it. I am creating a document for 3 shifts, within each shift, every hour my line workers have to fill out a document that contains a few different numbers and percentages, so im trying to create 8 hours, that auto populate into one sheet for their 8hr shift, x3 for 3 shifts, ive then auto populated their entire shift sheet onto a totals page, which shows each shifts totals, then auto populated the shift totals to a cell for daily totals. The problem ive run into is i want to create a calander that pulls that info by date and populates it into the calendar which then will populate it into a graph, so he can take to meeting. I have done most of the work, but i cannot figure out how to have excel populate info from one day to the next without erasing the previous days info. Is there any way to do this?
Everything starts from the top left corner of every shift sheet which goes to shift totals, which goes to daily totals on the same page which then goes to the calendar and then the graph.
I havend done each sheet yet for every hour, thats easy once i figure out the calendar part. Thanks for any and all help.