WorkBook Update

[NotGood@All]

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

 

[Khoshravan]

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]

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??

 

[Gord Dibben]

Each workbook will have to opened one at a time and changes made.

You could use VBA code.

Ron de Bruin's site will give you some ideas which you would have to
edit/adjust to suit your needs.

http://www.rondebruin.nl/copy4.htm


Gord Dibben MS Excel MVP