Disaster!!

I spent the afternoon working on a rather complicated spreadsheet that I have designed to plan duty rosters. It is an update to an existing workbook that uses various links to other spreadsheets for data, which it then calculates to make sure that there are enough people on duty and has been a godsend for those using the original version.

However, about 10 minutes before the end of my working day today, this happened and one of the major links sort of got lost and I was faced with this screen and needed to manually go through all of them to recreate the link.

Hundreds of changes to be made so thank goodness for copy and paste functions.

Thanks to all those who commented on my 300th blip yesterday.