Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
all sheets need the same
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I print sheets in Excel without blank sheets after page | New Users to Excel | |||
Multiple Sheets (Need to create 500 individual sheets in one workbook, pulling DATA | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
In 3 active sheets in wkbk, determine& display the # of sheets that have data | Excel Discussion (Misc queries) | |||
populating sheets based on data from parent sheets | Excel Discussion (Misc queries) |