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

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

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

Sorry I mistook work book with worksheet. What I am talking about is valid
for worksheet. I am not sure about the extension of this method for workbook.
As a short cut, if there is no special reason to keep peoples data in
different workbooks, by keeping their data in different worksheets, the
method I explained is applicable.
Or I have to check for extension of this method on workbooks.

"NotGood@All" wrote:

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

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

On Mon, 2 Feb 2009 10:58:14 -0800, 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