Dynamic Time Line

[Minkey]

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. ?

 

[shades]

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?
________
Chrysler La Engine History

 

[Minkey]

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