Automatically insert a formula into multiple sheets

  • Thread starter Thread starter maestes
  • Start date Start date
M

maestes

I have several workbooks that each contain several worksheets. I'd lik
to be able to automatically insert an =AVERAGE calculation in a specifi
empty cell of each worksheet. The location would be the same in eac
sheet (M6).

Is there a way I can easily do this so I don't have to click throug
each sheet
 
"Group" your sheets together, so that whatever you do to one, will be done
to *all* the sheets in the group.

Click the tab of the first sheet.
Hold <Shift> and click the tab of the last sheet.

All tabs are now white, with the name of the "master" sheet in bold.
There is the word "Group" appended to the end of the WB name in the title
bar.

Now make your revisions.
When finished, right click in a tab and choose "UngroupSheets".

You don't necessarily have to group all the sheets.
You can group any sheets you wish by holding <Ctrl>, and then clicking on
individual tabs.

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I have several workbooks that each contain several worksheets. I'd like
to be able to automatically insert an =AVERAGE calculation in a specific
empty cell of each worksheet. The location would be the same in each
sheet (M6).

Is there a way I can easily do this so I don't have to click through
each sheet?
 
Back
Top