Hi,
Most things I have a go at and some things I can work out but, I have an idea of something I want and don't have a clue where to start this time.
I have attached a holiday tracker for work which when I input the amount of hours holiday worked each day as can be seen on the days of the year, it gives me a total use, remaining, percentage... ect.
I have removed the names for protection reasons so you can not see a lot of the data but that shouldn't matter for this example.
Lets use the Payroll Number(E) instead of Name(D) then I can change it later.
What I would like to do is generate a list of holiday booked to make it easier to see/review, and is it possible to make this live so that as holiday is added/removed the list updates?
Initially I was thinking a separate workbook, but a new sheet would work just as well, no fantasy formatting just a list something like..
Week 48
519916 01/01/20
520643 01/01/20
526066 01/01/20-03/01/20
525183 01/01/20
514962 01/01/20-02/01/20
519229 01/01/20
529411 01/01/20
596452 01/01/20
621273 02/01/20
So that would be the result for week 48, but a continuous list for the entire year.
Not sure if this is possible, like I said its just an idea.
Thanks in advance
Tez
Bookmarks