Hi!
I'm very new to Excel, so please excuse any mistakes or if I should explain my problem more thoroughly.
A panel of 10 workers
So, I have an Excel document with one worksheet for every person that's a part of a small panel of 10 that I'm working with, and one worksheet with all of them in (main) in a row. Every time this panel does a survey, we add another column of data in the main worksheet with their results of how they did on the survey and the date on top.
This data also has to be inserted into the worksheet for every person on the panel seperately, which is a bit of a pain. What I'd like to do is to be able to insert the data in the main worksheet and have the rest of them update automatically. Each worksheet for each person on the panel also has a graph on it, which needs to display the data I added in the main worksheet (the graph shows the last 10 surveys or something like that).
I hope I'm being clear enough.
Cheers.
Bookmarks