Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Using a formula to create named range reference
Is it possible to use a formula to create a reference to a variable
named range? For example, I want a given cell to refer to a named range. However, the specific named range it would reference is dependent on today's date. I have named ranges for each weekday, i.e. Data2, Data3, Data4, Data5, Data6. In the cell which will reference these ranges, I want to create the reference to the range as "Data"+ WEEKDAY(TODAY()). I can't find any docs to describe how to accomplish this. TIA, Rose |
#2
|
|||
|
|||
something like
=IF(INDIRECT("Data"&WEEKDAY(TODAY()))100, "Yes","No") -- HTH RP (remove nothere from the email address if mailing direct) wrote in message oups.com... Is it possible to use a formula to create a reference to a variable named range? For example, I want a given cell to refer to a named range. However, the specific named range it would reference is dependent on today's date. I have named ranges for each weekday, i.e. Data2, Data3, Data4, Data5, Data6. In the cell which will reference these ranges, I want to create the reference to the range as "Data"+ WEEKDAY(TODAY()). I can't find any docs to describe how to accomplish this. TIA, Rose |
#3
|
|||
|
|||
Hi!
I think this is what you're looking for: INDIRECT("data"&WEEKDAY(TODAY())) So that: =SUM(INDIRECT("data"&WEEKDAY(TODAY()))) would Sum the named range Data4 However, if Data4 is a DYNAMIC range this will not work. Biff wrote in message oups.com... Is it possible to use a formula to create a reference to a variable named range? For example, I want a given cell to refer to a named range. However, the specific named range it would reference is dependent on today's date. I have named ranges for each weekday, i.e. Data2, Data3, Data4, Data5, Data6. In the cell which will reference these ranges, I want to create the reference to the range as "Data"+ WEEKDAY(TODAY()). I can't find any docs to describe how to accomplish this. TIA, Rose |
#4
|
|||
|
|||
Bob Phillips wrote:
something like =IF(INDIRECT("Data"&WEEKDAY(TODAY()))100, "Yes","No") Thanks a bunch, Bob!! I actually was trying to get the contents of the named range to appear so I did =INDIRECT("Data"&WEEKDAY(TODAY())) and it worked like a charm. Thanks a MILL! I am just a casual user of Excel so I never would've figured this out on my own. (on the 8th day, Dog created newsgroups...) Rose |
#5
|
|||
|
|||
Biff wrote:
Hi! I think this is what you're looking for: INDIRECT("data"&WEEKDAY(TODAY())) Yup - that's it exactly. Thanks!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formula, noncontigous range | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Identifying single column within named range | Excel Discussion (Misc queries) | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |