Display range of cells in popup window
 

Hi,
I need to have a window permanently displayed above a worksheet (like a Form) but I need it to display a Pivot Table which is on another worksheet. I thought about using the NewWindow function and resizing the windows to show both, but this is very fiddly if the user has a different screen resolution.
Is there a way to show the cells on a form, or a better way to use the Windows.

Thanks
Ashley