excel not have ability to do this fancy thing you want without macros. it
take some time and expertize to do this i think.


"mariekek5" wrote in message
...
| In advance thanks to everybody who is helping me out... I am quite an
amateur
| in Excel ;)
|
| I am working on an Excel document, to which different users have access.
The
| document also contains many links (via the INDEX formula).
|
| Some basic information (which indicates a certain product) needs to come
| back in every sheet.
|
| So if I have 4 sheets, lets say:
| - general information
| - prices
| - marketing
| - distribution
|
| Then every sheet should start with the same columns (lets say: unique
| identification number, registration name etc.).
|
| Two questions:
|
| 1) is it possible that if someone in sheet 'general information' clicks on
a
| unique number, that that number then automatically highlights in the other
| sheets? Or is there some other way that people do not need to scoll and
| search to get to a certain product in a certain sheet (I do know about the
| search option with control F, but I am looking for something even more
| sophisticated, and more user friendly).
|
| 2) Then, if one needs to delete or add a specific product, it would be
nice
| if this should only be entered once. So that people not need to fill in a
new
| unique identification number, registration name etc. in the 4 different
| sheets.
|
| I hope someone knows something about how to present the sheets nicely, and
| user friendly!
|
| Thanks a lot in advance.
|
| Marieke