I don't think you'll find an easy way to do this.

You could move the worksheets into a common workbook, do the grouping, then the
changes and move one of the worksheets back into the original workbook.

But it sounds like your changes would be too complex for this to work.

Personally, I would do my best to put all the information I needed into a single
worksheet. Then I may be able to enter a unique value (like name or SSN or
employee id) in a cell and use a bunch of =vlookup()'s to retrieve the values I
need for that workbook.



Pat Hughes wrote:

I want to edit 2 workbooks at the same time. They have same info except one
includes phone numbers and one doesn't. THey are lists of officers in
different divisions which change each month. I want to make the changes to
both workbooks at the same time so I don't have to do it twice. I feel this
should be easy. For example when you edit 2 worksheets you can press shift
and click on the tab of the worksheet you want to edit. I want to edit 2
workbooks at the same time moving the names of the officers around.
Any ideas?
Thanks

--

Dave Peterson