Pop up

wcmash

New Member
Joined
Nov 14, 2006
Messages
11
I have a spreadsheet with data in a1-b10 and I would like a popup window that i could move to another screen that someone else is looking at. When i update the data in a1-b10 i would like the changes to be seen in the popup. Is this possible?
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
What do you mean with "move to another screen"? Is it for instance a second screen that you use for your laptop?

What data is in cells A1:B10? Plain text, formulas? How should the popup look like?
 

wcmash

New Member
Joined
Nov 14, 2006
Messages
11
Column A will be Names and Column B will be a score from an applause meter so it will be numbers. Yes I have a laptop and the other screen is a projector that will display the box that is needed.

Thanks
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
By far the easiest method to solve this, is to use the "switch window" functionality. Any changes to the sheet will be visible in the other sheet, no need for coding.
 

wcmash

New Member
Joined
Nov 14, 2006
Messages
11
Switch Window??? I don't want any of the toolbars or title bar to be seen just a window with the data.
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
Switch Window??? I don't want any of the toolbars or title bar to be seen just a window with the data.
Apologies, I wrote a typo. I meant "New window".

Well, it seems that you cannot move that "second Window" to the second screen, so I am not sure this is the solution.

So maybe you will need to look for a programmatic solution.
 
Last edited:

wcmash

New Member
Joined
Nov 14, 2006
Messages
11
I guess that would work but would really like to make this just show data no column letters, row numbers, lines or anything else.
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
I guess that would work but would really like to make this just show data no column letters, row numbers, lines or anything else.
Can you move an Excel sheet to that second screen while another one (with the base data) is on your screen?
 

wigi

Well-known Member
Joined
Jul 10, 2006
Messages
7,944
Actually no it just moves in the main excel window.
That's what I was fearing.

Can you open up a second Excel APPLICATION (so the program of Excle) rather than a second file in the same Excel application. If possible, you should be able to drag that one to the other sheet.
 

Forum statistics

Threads
1,082,500
Messages
5,365,935
Members
400,863
Latest member
kimtid

Some videos you may like

This Week's Hot Topics

Top