Source Template Tab

[Tim0705]

Good morning,

I have a beast of a spreadhseet where I have 60 members of staff that I need to keep record off with details about their training records. Each member of staff has its own tab. Unfortunately when i want to change the tab (i.e new courses have to be added) i have to add the row to every tab individually which is very time consuming. Does anyone know if there is away of having a tab that acts as the master layout which every other tab duplicates and when i change it the change applies across all the tabs. But each tab will have its own content against the formatting?

Appreciate your help and support in advance.

Kind regards

Tim

 

[Herakles]

Good morning,

I have a beast of a spreadhseet where I have 60 members of staff that I need to keep record off with details about their training records. Each member of staff has its own tab. Unfortunately when i want to change the tab (i.e new courses have to be added) i have to add the row to every tab individually which is very time consuming. Does anyone know if there is away of having a tab that acts as the master layout which every other tab duplicates and when i change it the change applies across all the tabs. But each tab will have its own content against the formatting?

Appreciate your help and support in advance.

Kind regards

Tim

Can you please post a good representative example of the data in one of the worksheets and an indication of how / where a new course / row would be added?

Use XL2BB as then members can copy and paste the data for development purposes.