Hi,
I've created a workbook which summarises the timesheets for everyone within my organisation through links to their individual timesheets saved on my C:/ into a single sheet which prints out for CEO authorisation.
Is there a way to create a link to a folder which will be rolled over each fortnight, without having to go and update the link for each individual timesheet?
I recorded a macro which goes through and updates the information for each individual. However, is there a code which will leave a generic location for the folder these timesheets are in, which can be updated on startup of the sheet?
Please help
I've created a workbook which summarises the timesheets for everyone within my organisation through links to their individual timesheets saved on my C:/ into a single sheet which prints out for CEO authorisation.
Is there a way to create a link to a folder which will be rolled over each fortnight, without having to go and update the link for each individual timesheet?
I recorded a macro which goes through and updates the information for each individual. However, is there a code which will leave a generic location for the folder these timesheets are in, which can be updated on startup of the sheet?
Please help