Is there a way I can make my excel file 'automated' so that:
1/ When new rows of data are added to Sheet1, Sheet 2 automatically updates its 'tiers' data (Sheet2, yellow part and the rows of data) and Sheet 3 produces a new regression (both the values and the graph) automatically?
2/ If I filter Sheet1 according to country or any other filter, then Sheet 2 filters the data remaining and Sheet3 produces a regression on the remaining data automatically?
If you want you can have 3 sheets (1 per tier) for the 'calculations' part. The setup doesn't matter so long as its automated once data in Sheet 1 is filtered.
I have attached an example in Excel - all the data is made up so feel free to use it as an example.
Any help would be greatly appreciated. Instructions would be helpful too so I can do it on my own data.
Thank you.
Edit - the file didn't attached (excel file) so I uploaded it here: http://www.sendspace.com/file/y9srtm
Edited by LSEactuary, 11 July 2013 - 08:13 AM.