Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

David

share|improve this question
    
There doesn't appear to be a question here. Are you trying to find an easy way to Refesh the view? –  CharlieRB Dec 21 '12 at 12:46
    
I don’t understand the question, either — but does the (F9) key do what you want? –  Scott Dec 21 '12 at 18:17

2 Answers 2

Does the Filter -> Reapply command not do what you want? You can probably write a small VBA routine to run this command whenever the underlying data is updated.

share|improve this answer

To repeat an action every 10 minutes:

When the workbook first opens, execute this code:

alertTime = Now + TimeValue("00:10:00")
Application.OnTime alertTime, "MyMacro"

Then just have a macro in the workbook called "MyMacro" that will repeat it.

Public Sub EventMacro()
    ActiveSheet.AutoFilter.ApplyFilter ' adjust to point to your filter
    alertTime = Now + TimeValue("00:10:00")
    Application.OnTime alertTime, "EventMacro"
End Sub
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.