Workbook to automatically refresh every 30 seconds (or similar time)

[Dancey_]

Hey guys,

Competely fresh to this one, so dont have any code to post.

I plan on making a sales leaderboard for the company I work for. It will be displayed on a 46 inch TV we have suspended from the ceiling.

The idea is that the spreadsheet is linked in to a 'database' that I have built that is updated by our sales agents.

Manually I can create and update a leaderboard no problem at all.

All I need is a Macro that will automatically update every 30 seconds or so once I press a button and then stop either when I press it agian, or when I tell it to.

Any help please?

Cheers