bikeordie1
New Member
- Joined
- Jun 28, 2012
- Messages
- 46
So what i have is about 50 sheets all formatted generally the same that contain various bits of info on products. On one sheet i have the list of all the products by Code# and they're all hyper-linked to the corresponding sheet. at the top of all the other pages is a button to bring you back to the first worksheet with the list, thus the ability to jump around to different products without hunting for a tab.
What id like to have is some sort of split screen effect so my list can remain on the left hand side of the screen and when clicked the right hand side of the split screen goes to the corresponding sheet.
I have experience in VBA so that's an option if there isn't something "built in"
Thanks for your help!
What id like to have is some sort of split screen effect so my list can remain on the left hand side of the screen and when clicked the right hand side of the split screen goes to the corresponding sheet.
I have experience in VBA so that's an option if there isn't something "built in"
Thanks for your help!