Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Adam Kroger
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert relative to absolute addressing instantly in Excel loudun Excel Discussion (Misc queries) 3 November 24th 05 06:37 PM
VBA Cell Addressing Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 5 March 16th 05 10:51 PM
Relative Addressing Bill Martin -- (Remove NOSPAM from address) Excel Discussion (Misc queries) 4 February 20th 05 05:43 AM
Indexing / Cell Addressing A_n_d_e_r_s Excel Discussion (Misc queries) 1 February 10th 05 12:47 PM
Relative addressing using names or labels in formulas? Tony Excel Worksheet Functions 1 November 21st 04 10:49 PM


All times are GMT +1. The time now is 12:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"