M
mariekek5
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
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