Edit 2 workbooks at same time

[Pat Hughes]

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]

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.

 

[Jim]

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

 

[future_vba_expert]

I would think the best way is to reference the cells in one sheet from the
other sheet like so:

in cell a1 of sheet 2 enter:
=Sheet1!A1

if this was in cell a1 on sheet2, then it would always have the same value
as cell a1 on sheet1. Do for as many cells as required, via copy and paste.
Is this the sort of thing you are looking for?