I have several worksheets that have the same rows and headers but different
data and I'll need to add new rows with headers as new projects start. Is
there a way to do this automatically without having to manually add rows and
headers to each sheet?

You can select multiple sheets at once and now changes are being made to all
of the selected sheets at once. To select multiple sheets

Select the first sheet
Now hold down the Ctrl key and select more sheet. The tab on each sheet you
select will highlight.
You can also hold down the Shift key to select all sheet from the first
selected sheet to the sheet you are selecting.

To remove the multi select just select a sheet that is not currently part of
the selected sheets.
--
HTH...

Jim Thomlinson


"Chesil" wrote:

I have several worksheets that have the same rows and headers but different
data and I'll need to add new rows with headers as new projects start. Is
there a way to do this automatically without having to manually add rows and
headers to each sheet?