Firstly I'm using excel 2010.
I have had a look at other "auto-update" and from what I saw they wanted you to type some information in to make it "refresh" the auto-update.
Essentially what I have is two seperate spread sheets and I have a table with filtered headings and I have a sheet with LOTS of raw data. All I have is three collumns on the table however I do not physically put any data into it. When the other spreadsheet is updated the references automatically place the values into my table.
For example the filter is set to "UK" but we still require to have all values there just incase reference is needed as the people using this spreadsheet are not allowed to see the workings spread sheet due to confidentiality reasons.
I hope that someone can understand what I am asking about as I didn't know what to search for to find this so my apologies is there is something already out there to do with this.
It's not too urgent but would just make my life that little bit easier rather than un-filtering and re-filtering.
Thank you for your time and I will happily try anything out.