| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Dynamic reference to a sheet
A have the following sheet :
A1 | Day A2 | 1 A3 |- (cel a1 from sheet Day (1) - A4 |- (cel a2 from sheet Day (1) - A5 |- (cel a3 from sheet Day (1) - A6 |- (cel a4 from sheet Day (1) - A7 |- (cel a5 from sheet Day (1) - A8 |- (cel a6 from sheet Day (1) - And I have 60 days, I want to make a formula that automaticaly reference the correct sheet according the number above Day . The name of the sheet will be something like Day (n), where n is the number in the cel A2. Something like cel A3 : ='Day (value of cel A2)'!A1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| How do I reference values from 200 worksheets onto a summary sheet | Excel Discussion (Misc queries) | |||
| How do I reference non-contiguous columns in another sheet and th. | Excel Discussion (Misc queries) | |||
| Need formula for sheet & cell reference | Excel Worksheet Functions | |||
| Naming & renaming a sheet tab | Excel Worksheet Functions | |||
Threaded Mode
