LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 70
Default Freezing Workbook across worksheets

I have a workbook with multiple sheets. It's a database with each row as a
record. Each sheet starts with a Name and ID Number feild which are the same
throughout all the sheets. When on sheet one, if I scroll to record 150 to
reveiw data on that sheet, the other sheets don't move along with it. So if
I wanted to look for the data of record 150 on any other sheets, I have to
scroll to them as well.

Is there any way to freeze or lock or virtually connect these sheets
together so that, for instance, when I scroll down to a line on one sheet,
I'll be placed at that same place on all the other sheets as well? What
would even be better, is if I highlighted a row on one sheet, if all the
other sheets could get that same line highlighted also. I'm not sure if
that's possible but if anyone has any ideas, please pass them along.

I appreciate any guidance you can give me and thanks in advance.
-Dax
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Command to count number of worksheets in a workbook? Saul Fowler Excel Worksheet Functions 3 February 6th 08 12:46 PM
Data referencing and auto fill across worksheets in one workbook.. Corey Helms Excel Worksheet Functions 0 July 17th 06 03:44 PM
How do I open several worksheets from the same workbook on screen Innovman 2006 Excel Worksheet Functions 4 June 12th 06 04:57 PM
Protecting all worksheets of a workbook neeraj Excel Discussion (Misc queries) 14 May 30th 06 09:46 PM
How do I build a workbook from the worksheets another workbook? Rico Excel Discussion (Misc queries) 4 August 19th 05 02:04 PM


All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"