Create a template for every worksheet
I need to create a template that can be updated later for 80-some worksheets
in a workbook. Basically, each tab has some information in common (which is
updated every year) but some information which is unique. In the past, I
just created the first worksheet without any unique information, and
copied/pasted to new worksheets. The problem is, if I need to update
something on all of them, I have to go back to everyone individually and
copy/paste. Is there a way to make a template that will automatically update
all worksheets based on it? Thanks!
|