This is a bit tricky (though not for you guys I'm sure ;)) but my collegue has created a spreadsheet to allocated resources thoughout the day and one thing we would like is to have a dynamic time line that will scroll across the sheet as the time changes (at 15 mins intervals).

We can do it when a part of the spreadsheet is updated or when a button is manually clicked (changing the colour of the everything in the past), but would ideally like it to be fully dynamic. Is this possible ?

For a quick hack I was thinking of an event that would update the spreadsheet at a given interval (but not actually doing anything to the spreadsheet) or if you have any other suggestions. ?

Howdy. Yes, this is possible. It depends on your setup. But you could have VBA timing to trigger every so many minutes, or manually, or automated every time a change occurs. Do you have a sample of how the data is laid out?

But you could have VBA timing to trigger every so many minutes
This would be ideal do you have an example you could share ?

Do you have a sample of how the data is laid out?
I can't show you an example unfortunately but basically we have a resource (person) that has their own row which is populated with a job between a time slots (15 mins intervals). Kind if like this:

________07:00 07:15 07:30
Jo Bloggs [ * ] [ * ] [ * ]

* single cells

Hope this is enough to go on - thanks