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

"Clark" wrote:

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.

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

"Clark" wrote:

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.

That's what happens when you use the CDO <g


--


Regards,


Peo Sjoblom



"Bob Umlas, Excel MVP" wrote in
message ...
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

"Clark" wrote:

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.

"CDO"??? What's that?
And WHAT's what happens? -- my post going in twice? (maybe I was in [group]
mode!)

"Peo Sjoblom" wrote:

That's what happens when you use the CDO <g


--


Regards,


Peo Sjoblom



"Bob Umlas, Excel MVP" wrote in
message ...
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

"Clark" wrote:

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.

CDO is the web interface of the newsgroups


--


Regards,


Peo Sjoblom


"Bob Umlas, Excel MVP" wrote in
message ...
"CDO"??? What's that?
And WHAT's what happens? -- my post going in twice? (maybe I was in
[group]
mode!)

"Peo Sjoblom" wrote:

That's what happens when you use the CDO <g


--


Regards,


Peo Sjoblom



"Bob Umlas, Excel MVP" wrote
in
message ...
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

"Clark" wrote:

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.