Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have an excel worksheet with three sheets. Sheets 2 and 3 are locked so
that entries can be made in only certain cells. Sheet 3 is linked to sheet 2 so that when an entry is made on sheet 2, the entry appears on sheet 3 in the corresponding cell. I would like sheet 3 to open in the cell the last entry was made (which is the corresponding cell on sheet 2 because sheet 3 is completly locked except for the link to sheet 2) Is there a simple way to perform this task? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open existing Excel file | Excel Discussion (Misc queries) | |||
unable to open Excel file by double clicks | Excel Discussion (Misc queries) | |||
Need to remove a password that noone placed on Excel worksheet. | Excel Worksheet Functions | |||
Is there a way to make Excel 2000 open a new worksheet in a new w. | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel |