I need to build a report that looks at the results from a csv file I paste into my report and then graph them, I paste the csv file into my report every fortnight to record the recent data. The problem I have is that the Area's that I am reporting against as seen in the attachment (column A)can occasionally change, for example one fortnight there might be 4 areas and then the next there might be 5 areas, more often than not the number of areas can increase(albeit not that often but often enough to cause me problems), even less often the number of areas can be reduced.
What I want to do is keep a record of all Areas that have been in the csv files and have the resulting numbers populate under each date that I paste the csv file in. Set up like as seen in the Graph Figures tab(if this is the most suitable option), allowing me to then graph the results for each Area irrespective of wether the area has been there the whole time or is only a new area.
The attachment I have set up the first 4 tabs as examples of what I would paste into my report, I would only paste them into one tab and then next fortnight or month paste the next report directly over the top of it. The attachment is just an example of 4 different dates data that will be used. The results are to populate in the Graph figures tab.
Hope someone can help.
Bookmarks