Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing seperate data in a worksheet
i want to be able to pop-up data that is in a different area of a worksheet
without changing my current position. I don't want to edit data that i'm trying to see...i just want to be able to "refer" to it from time to time without changning my position and i want to keep my curent p[osition in the sheet to edit data in that position while refering to other data for info. kinda like a pop-up info sheet where tha data comes from another position in the sheet. Can this be done |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing seperate data in a worksheet
Hi Gate,
You can split screen and use scroll lock, which does not require code, but if you want to use code try something like this, going to have to experiment to get the data you want visible: Sub Macro1() ActiveWindow.SplitColumn = 10 ActiveWindow.SmallScroll ToRight:=1 ActiveWindow.SplitRow = 16 End Sub "Gate" wrote: i want to be able to pop-up data that is in a different area of a worksheet without changing my current position. I don't want to edit data that i'm trying to see...i just want to be able to "refer" to it from time to time without changning my position and i want to keep my curent p[osition in the sheet to edit data in that position while refering to other data for info. kinda like a pop-up info sheet where tha data comes from another position in the sheet. Can this be done |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
viewing seperate data in a worksheet
Use your macrorecorder and slpit the screen where your data is located.
Sub Macro2() Range("Z100").Select ActiveWindow.SplitRow = 8 ActiveWindow.SplitColumn = 9 End Sub "Gate" wrote: i want to be able to pop-up data that is in a different area of a worksheet without changing my current position. I don't want to edit data that i'm trying to see...i just want to be able to "refer" to it from time to time without changning my position and i want to keep my curent p[osition in the sheet to edit data in that position while refering to other data for info. kinda like a pop-up info sheet where tha data comes from another position in the sheet. Can this be done |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation against seperate worksheet | Excel Worksheet Functions | |||
Data in a seperate worksheet | Excel Discussion (Misc queries) | |||
Viewing 2 seperate spreadsheets on the screen simultaneously | Excel Discussion (Misc queries) | |||
viewing seperate data within worksheet | Excel Worksheet Functions | |||
Searching for data on seperate worksheet | Excel Programming |