I have taken on a massive task at work that is becoming more time consuming than I planned for. I am hoping a genius has a solution so here we go.
Each day at work we make an Excel report of where staff is located. I am trying to accumulate all the data from 2016 since the person tasked with that before me did not. (I am trying not to be to vague please forgive me) The first sheet is the all tab with just everyone's names listed, the following tabs have specific places where employees are and who was there. This changes daily sometimes. The data worksheets names change often. Aside from the first and last page there is no uniformity. (This really sucks) I have started this and am only up to March 2016 after a week.
I created a spread sheet to use. I placed the locations across column one and begin to fill in the columns manually by opening up each days report (for instance Excel file Staffing 2.3.2016.xls). Is there a program I can use to help expedite the movement? I asked my IT department if I could use a script and because of protocol I was told no. ANy suggestion or help would be greatly appreciated.
Each day at work we make an Excel report of where staff is located. I am trying to accumulate all the data from 2016 since the person tasked with that before me did not. (I am trying not to be to vague please forgive me) The first sheet is the all tab with just everyone's names listed, the following tabs have specific places where employees are and who was there. This changes daily sometimes. The data worksheets names change often. Aside from the first and last page there is no uniformity. (This really sucks) I have started this and am only up to March 2016 after a week.
I created a spread sheet to use. I placed the locations across column one and begin to fill in the columns manually by opening up each days report (for instance Excel file Staffing 2.3.2016.xls). Is there a program I can use to help expedite the movement? I asked my IT department if I could use a script and because of protocol I was told no. ANy suggestion or help would be greatly appreciated.
