Any Excel gurus in here? There is a job I do daily, and I cant help but think I am doing it in the most inneficient way possible 
I am given a spreadsheet with a lot of information. Basically everything done at my site in the last 24 horus. I then use this to create a whole bunch of tables and charts to make it easier for people to read.
The problem is, the only way I can think of doing it is to filter down to what I want for that chart, then copy it over to a new sheet in the book, then create the pivot table from that.
Depending on how busy we have been, and/or any issues we have I can end up with dozens of sheets, all with what I am guessing is redundant data. I have 3 shifts, 4 sections, each section with 4 sections of their own. Honesty it's a mess.
It's purely for my own sanity. I get the data pulled from the server before I get in to work, and before I go home I give the upper managers their fancy charts and graphs. Only I see the inbetween, but its getting annoying. There has to be an easier way!
I am given a spreadsheet with a lot of information. Basically everything done at my site in the last 24 horus. I then use this to create a whole bunch of tables and charts to make it easier for people to read.
The problem is, the only way I can think of doing it is to filter down to what I want for that chart, then copy it over to a new sheet in the book, then create the pivot table from that.
Depending on how busy we have been, and/or any issues we have I can end up with dozens of sheets, all with what I am guessing is redundant data. I have 3 shifts, 4 sections, each section with 4 sections of their own. Honesty it's a mess.
It's purely for my own sanity. I get the data pulled from the server before I get in to work, and before I go home I give the upper managers their fancy charts and graphs. Only I see the inbetween, but its getting annoying. There has to be an easier way!
