Hi,
Hope I'm posting this in the correct section - apologies if its not.
I've been using a workbook I created for annual leave recording at my employer for a year or so. It fulfils my needs but needs to go on a shared network drive in order to allow my deputy to access the workbook.
The problem is the sheet is 125mb in size and takes an age to download & then save to the companies network drive.
The sheet is made up of the following:
staff list - where hours are inputted, which then once sorted automatically feed in to
weekly breakdown
individual holiday record
annual list.
There are some macros & some conditional formatting in the sheets so that i can see when i reach the list of staff allowed off for the day.
I did try uploading the file here but it was taking ages so here is a link where you can download it from.
https://drive.google.com/file/d/0B7V...ew?usp=sharing
Would some via coding make it more compact/slicker?
Thanks in anticipation for your help
Bookmarks