How about using link.provided that you have an exact content. eg. in Workbook
B cell A1, you press "=" then point to WB A cell A1. You will get Absolute
link. Now you can remove the absolute sign ("$") from the cell A1 in Workbook
B. You can now copy this to other cell. Will it help? You have to remove the
mergecell fotr the copy to work though. Have a good weekend

"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