| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Indirect and Address in Reference to other sheets
I need to have a column auto-updating from every-other column of a row on a
different worksheet - literal example: 'ValleyResultsVsBadDay' column A is identical to Column (B,D,F,H,J,L, etc. - all the even-indexed ones) Row 5 of 'ValleyLots'. Is there a way to use Indirect and Address to refer to a different worksheet like that, or is there a simpler, quicker way to make a function for that task? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect function? | Excel Worksheet Functions | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| Summing a range using INDIRECT & ADDRESS | Excel Worksheet Functions | |||
| Construct address as a reference not "text" | Excel Worksheet Functions | |||
| Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Linear Mode
