Hi all.
Just to say, before I seek your advice - I am completely self-taught on Excel and can handle the basic formulas etc, so please excuse me, if I'm not using the most appropriate process or formulas in devising my workbooks etc.
I devised a spreadsheet for my wife, who works with teaching staff, who attend various schools in our area. The main worksheet gathers all the information together for each term, so it lists each school, each teacher and how many hours the teachers have logged at each school. So Column A is school name, B is Teacher Name, C-N are the week numbers and O provides a total
This is then linked to seperate worksheets, each of which is effectively an invoice for each school. This simply pulls through the data from each, so for example column B shows teacher name, C-N shows hours and O gives totals.
All works fine, but there's an issue when it comes to the new school year. If I try to Create a copy of the folder for say 2016 and rename it, the formulas linking the invoice to the master sheet go a little haywire, so we end up having to redo them all.
Is there an easy way to create a duplicate, without throwing the formulas out ? I'm probably missing something simple, but would appreciate your help.
Many thanks.
Rob
Just to say, before I seek your advice - I am completely self-taught on Excel and can handle the basic formulas etc, so please excuse me, if I'm not using the most appropriate process or formulas in devising my workbooks etc.
I devised a spreadsheet for my wife, who works with teaching staff, who attend various schools in our area. The main worksheet gathers all the information together for each term, so it lists each school, each teacher and how many hours the teachers have logged at each school. So Column A is school name, B is Teacher Name, C-N are the week numbers and O provides a total
This is then linked to seperate worksheets, each of which is effectively an invoice for each school. This simply pulls through the data from each, so for example column B shows teacher name, C-N shows hours and O gives totals.
All works fine, but there's an issue when it comes to the new school year. If I try to Create a copy of the folder for say 2016 and rename it, the formulas linking the invoice to the master sheet go a little haywire, so we end up having to redo them all.
Is there an easy way to create a duplicate, without throwing the formulas out ? I'm probably missing something simple, but would appreciate your help.
Many thanks.
Rob
