I have an Excel worksheet that works as template for a questionnaire. My aim was simply to copy the worksheet into a new one while preserving the formatting and other stuff, and I could then just fill it out.
For example, say I gather some customer polls each year so that I have worksheets 2010, 2011, 2012 and so on.
My possible dilemma comes when I want to gather all that data together into one sheet and create some graphs out of them. Say I have gathered the data from years 2010, 2011 and 2012 and made some fancy graph out of them to show how customer opinion has changed over the years. Now, what if I add another worksheet for the year 2013?
Is there a simple way to automatically include this new data into the graphs dynamically, so that it gets updated without need for my input?`
Bear in mind that VBA and macros are out of the question as this Excel sheet is supposed to work on Mac 2008 version.