I've set up a macro that collects data from all numbered sheets (week numbers) and displays the data in 3 seperate tables. Each data type, for example "good eggs", has 3 different values for each of the 3 locations (stall 2, 3 and 4). I want to compare the difference between the 3 locations and also see if there's any correlation between two distinct data types. Here's what it looks like:
Attachment 645071
A while ago, I only had 4 data types per table. I used the 'define name' option in the 'formulas' tab so I could refer to each row individually - I do not want all data in one big graph - when creating a chart. Now that I have about 10 distinct data types, however, this method seems rather burdensome. What's more, it's not unlikely that I'm going to have to add more data types in the future, further increasing the amount of work with my original method.
So my question is: is there a faster, easier or better way to accomplish what I want? I'd like the process to be mostly automatic, if possible. I've also attached the file I'm working with. Most text (except macros) is in Dutch though.
Thanks in advance!
Bookmarks