northernstar
10-30-2007, 04:58 PM
hi again...nothing for a while then two at once....just like buses
i have created a spreadsheet to record and monitor employees' holidays and sickness and it works quite well except for the following problems:-
a) when changes are made because its quite a large file it takes a while to save and close?
b) when i need to add an employee it is a little long winded as i need to create a new sheet and then copy over the formulae changing the name of the sheet in the formula, and change which columns need hiding or showing as the department has now an extra employee - hope this makes sense -
would like a quick and easy way to add/remove employees and adjust the range of columns which need to be shown or hidden for each department - can i do this my naming the range? going to try it now
would appreciate any help or comments which would improve
i will need to email the file to anyone who is interested in looking at this for me as the zipped file is 706KB to big to upload on a thread
please let me know if anyone would like the file
thanks
i have created a spreadsheet to record and monitor employees' holidays and sickness and it works quite well except for the following problems:-
a) when changes are made because its quite a large file it takes a while to save and close?
b) when i need to add an employee it is a little long winded as i need to create a new sheet and then copy over the formulae changing the name of the sheet in the formula, and change which columns need hiding or showing as the department has now an extra employee - hope this makes sense -
would like a quick and easy way to add/remove employees and adjust the range of columns which need to be shown or hidden for each department - can i do this my naming the range? going to try it now
would appreciate any help or comments which would improve
i will need to email the file to anyone who is interested in looking at this for me as the zipped file is 706KB to big to upload on a thread
please let me know if anyone would like the file
thanks