Thank You, Do I just open all the workbooks, pick one, select all the tabs?
Any changes I make to one workbook will carry over to the other 14??
--
NotGood@All


"Khoshravan" wrote:

Select the first tab, press shift button and select last tab. Now all are
highlighted. Now they are like one worksheet. What ever you do in active
worksheet (It is underlined), it will be done on all selected worksheets.
This method has special name but I can;t recall the name.

"NotGood@All" wrote:

I have 15 workbooks for 15 people and 1 "totals" workbook, All the sheets
have the same format. I need to add some new rows and columns into all the
workbooks. Can I make these changes at one time like making changes to 1
workbook by highlighting all the sheets?

Thank You
--
NotGood@All