Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorksheet addressing (I think) in '97
I have a table on 1 worksheet_5 that is used to propagate data on
Worksheets_1 - Worksheet_4 There is a calculation that is specific to shets 1 - 4 When I select a specific entry form the table, I need a cell to be filled with the result of the calculation performed on THAT sheet ----------- Sheet_1 is for Salesman 2 Sheet_2 is for Salesman 3 Sheet_3 is for Salesman 4 Sheet_4 is for Salesman 5 Sheet_5 is for Data Cell AF7 contains a computation that is retuning a value specific to that city/worksheet In Cell A1 I have data validation that uses the row headers of a table on Sheet_5 There are about 30 rows to the table When a selection is made in A1, cell B1 is propogated from the table based on the selection made. 9 of the possible selections for A1 need to result in a variation of the Sheet specific computation to be placed in B1 --------------- How do I do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert relative to absolute addressing instantly in Excel | Excel Discussion (Misc queries) | |||
VBA Cell Addressing | Excel Discussion (Misc queries) | |||
Relative Addressing | Excel Discussion (Misc queries) | |||
Indexing / Cell Addressing | Excel Discussion (Misc queries) | |||
Relative addressing using names or labels in formulas? | Excel Worksheet Functions |