The second one I think is more complex.
Currently I get a CSV file of information wihich I import to a Pivot table, apply filters to get the information I need. I copy the pivot table into an ordinary worksheet. I have secondary information which I use to find look up the information I require out of the data from the pivot table. I copy and paste this into another template, match the fields and create the report.
the goal would be for the CSV information to be Inimported into a speadsheet, it matched with the current information we need the results on and the final information created. I have attached The final report with the information we use. We keep adding each months results. There are calculations rows 192 and 194 that I adjust with the addition of the new information.
The information form the CSV file is added by importing from Text, Delimited by Tab and | (not I). The Pivot Table is created selecting all the information. I then use the filters as shown. From here I use find matching the externalID with the AER numbers we wish to add.
Ideally this can all be one on importing. Flexibility required is the Recruitment Process as a filter. Some of the difficulties are the matching of the stsus. the finished table has less Status - The other status generated in the pivot table information are not relevant.
Let me know if this makes sense?
The site is telling me I have suploaded the CSV file and the Job Timing FY 2012-2013 Spreadsheet. Let me know if you dont have them. I had to split the Pivot table and Import into separate files as the whole thing was too large.