Thanks Gord,
I can have both workbooks open but only one at a time is visible.
I need to have both workbooks open and visible, one on each screen.
Therefore I need two instances of excel, one on each screen.
I know I can open both workbooks in the one instance of excel and switch
between them but that's not
what I need.
Mario
..
"Gord" wrote in message
...
http://www.cpearson.com/excel/MultipleMonitors.aspx
OR
You said the magic word...........copy from 1 to 2 while having both
workbooks open.
Gord Dibben Microsoft Excel MVP
On Sat, 10 Sep 2011 18:11:22 +1000, "Mario" wrote:
HI,
I'm using two monitors.
I need to have two(2) instances (separate spreadsheets) on my screens, one
spreadsheet on one
and different spreadsheet on the other.
I'm using Excel 2010 (student).
How do I allow/tell XL to allow more than one instance?
OR
How do I transfer/copy the data on sheet 3 of spreadsheet 1 to sheet 4 of
spreadsheet 2?
TIA.