Hi All,
Im building a new holiday database for my staff and to make it easier the database shows records of everyday they have booked off for the years, 01/01/08-31/12/08 i've built an external file called HolidayCard for Team Leaders to easily see what holiday their team members have, now it links to the database fine, but has massive gaps where it lists all 365 days.
Is their a macro i can run or a forumla to hide the cells that dont have holiday booked and unhide them if they do?
I found some code on here (forgive me but i cant find the link now) which almost worked but i think my forumales may be causing issues, as its basically if HolidayDatabase has nothing booked, Then "", otherwise show the holiday booked - i think usinga "" null command causes issues.
Any help appreciated.
Dan
Im building a new holiday database for my staff and to make it easier the database shows records of everyday they have booked off for the years, 01/01/08-31/12/08 i've built an external file called HolidayCard for Team Leaders to easily see what holiday their team members have, now it links to the database fine, but has massive gaps where it lists all 365 days.
Is their a macro i can run or a forumla to hide the cells that dont have holiday booked and unhide them if they do?
I found some code on here (forgive me but i cant find the link now) which almost worked but i think my forumales may be causing issues, as its basically if HolidayDatabase has nothing booked, Then "", otherwise show the holiday booked - i think usinga "" null command causes issues.
Any help appreciated.
Dan