Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
all sheets need the same first 6 columns - user friendly presentat
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
all sheets need the same first 6 columns - user friendly presentat
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Making a Form for User-friendly Macros? | Excel Discussion (Misc queries) | |||
User-friendly lookup solutions needed | Excel Discussion (Misc queries) | |||
I need a user friendly route sheet! Help! :} | New Users to Excel | |||
Looking for a production schedule excel/access & user friendly? | Setting up and Configuration of Excel | |||
Drill to Details - is there user friendly way to delete the sheet | Excel Worksheet Functions |