M
mike
Here at work, we have six people filling out weekly
spreadsheets with their work activity each week. Each
spreadsheet is identical, and all have a few formulas in
them.
The problem i forsee is when we need to make changes to
the sheets, such as adding clients, adding new columns,
etc. It appears as if I would have to manually go through
each and every spreadsheet(and every tab within each
spreadsheet) and update. Because there are formulas in
each sheet, I don't think I can just copy people's numbers
and paste.
My question is whether there is an easier way to make
broadscale changes over many spreadsheets.
spreadsheets with their work activity each week. Each
spreadsheet is identical, and all have a few formulas in
them.
The problem i forsee is when we need to make changes to
the sheets, such as adding clients, adding new columns,
etc. It appears as if I would have to manually go through
each and every spreadsheet(and every tab within each
spreadsheet) and update. Because there are formulas in
each sheet, I don't think I can just copy people's numbers
and paste.
My question is whether there is an easier way to make
broadscale changes over many spreadsheets.