all sheets need the same first 6 columns - user friendly presentat

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
 
H

Homey

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


| 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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top