Update Values (1 Viewer)

Hi All,

I am making a wall board that will be displayed in our central control hub for a private medical firm. It is only meant to be basic and just give a basic summary of the current events.

The wall board looks up values from a data entry workbook where the controller inputs data such as the vehicles current status such as on scene, hospital etc. However the values will not update if the wall board will only update if the wallboard and the data entry sheet are open in the same window of excel so I can't have them over a dual screen monitor. Is there anyway I can run a macro to get it update the values every ten seconds or so? I am baffled and not the best at macros!

Not sure if you have this resolved ?

Take a look at this link it will deal with timer events.

http://www.tek-tips.com/viewthread.cfm?qid=1179022

It isn't bullet proof though