Viewing same cells at the same time in two sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to open two separate worksheet files in the same window, then make
changes in cells to worksheet 1, and have those same changes occur in
worksheet 2.
 
Press Alt/F11 (takes you to the VBE), then Ctrl/G (activates the Immediate
window), then enter this:
application.Dialogs(xlDialogWorkgroup).Show
When you return to Excel you have all open workbooks and all sheets
selected. Deselect the sheets you don't want in the group, and then whatever
you do in one sheet will be done in the other, even if different workbooks.
HTH
Bob Umlas
Excel MVP
 
In the VBE, enter this in the immediate pane (ctrl/G):
application.Dialogs(xlDialogWorkgroup).Show
Deselect what you DON'T want, and then whatever you do in one workbook will
be done in both (all) for the selected sheets. If this is a duplicate post
(by me), it's because it seemed it didn't take the first time, so apologies!
Bob Umlas
 
"CDO"??? What's that?
And WHAT's what happens? -- my post going in twice? (maybe I was in [group]
mode!)
 
Back
Top