Hi,

I want to graphically show periods of time for resources - available, confirmed etc. My solution now is a VBA based one, where the user selects two cells in the overview, indicating the start and end date. A form is shown, the user picks the status and the data is stored in a data sheet:

1 - Data.jpg

A shape is also inserted in the overview sheet, indicating that period of time:

2 - Overview.jpg

(The shape may also be deleted by clicking on it and the corresponding data is removed from the data sheet - the code reads where the shape is located (dates and resource) and identifies the data through a string, which is a unique combination of dates, resource and status.)

Now, I would like to reverse it - without VBA - and have the user entering the data and using a formula to pull the data into the overview and format the cells according to the status, i.e. populating the data sheet and have the formula pull the data into the overview. I guess I could have done this with a diagram but prefer having it all presented in the sheet directly.

How should the formula in the overview look like?

Please get back if it's unclear what I'm after ;-)