| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate _worksheet_ for soruce data?
I want to get text data from a different worksheet depending on the value I
put in the formula. Can I name worksheets using numbers (1,2,3,...) and use changing values in formulas to refer to the different worksheet? e.g.: On my summary worksheet, different cells should get data from 1st cell = a value in a cell in worksheet 1 2nd cell = a value in a cell in worksheet 2 etc. -- sdm |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HELP! Find Data in columns next to known data then Calculate | Excel Discussion (Misc queries) | |||
| How do I calculate formulas for yes/no data | Excel Worksheet Functions | |||
| how to calculate the sum of the data copied from the net? | Excel Worksheet Functions | |||
| Calculate data on 2 different worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
