2 Identical Sheets, 1 for Display, 1 for Editing, Display Updates instantly

Hi All,

I need to have a Workbook displayed on a TV at work which will not be accessed easily, colleagues will input data into an identical Workbook which will then feed through to the TV display instantly.

At the moment it is simply =A1 in Cell A1 for example, which when the sheet is opened it updates, however if any changes are made I need the TV Workbook to update instantly for viewing.

The TV sheet needs to be open on display constantly.

Any suggestions?

Thanks
JD

Not sure if this would work, but is the workbook on 2 different PC units? If so the sheet could be made as a shared work book between the 2 stations.
Station 1 being updatable
Station 2 being the Display version.

If the Displayed version was set to auto save every couple of minutes then as station 1 was updated and saved, station 2 would reflect the edits on auto save.

Im no expert by a long way but logically this could work but would not be an instant update on station 2