C
Chris Brennan
Can the name box use the Indirect method for defining its name?
I wish to use a cell's value to define the name in the name box. I'
not sure if this is possible or if I'm just getting the syntax wrong.
I'm trying to group 7 days (cells) and then have Excel keep th
grouping as I copy them for subsequent weeks. I don't want to manuall
keep naming the groups as new weeks are added.
Example in the name box:
INDIRECT("week" & $A1)
where A1, A2, A3, etc. will contain the sequencial values 1, 2, 3, etc
Essentially, the names would end up being week1, week2, week3, etc.
I've just managed to Indirect much of the other functions of m
workbook and this seems to be the last part to fix.
Thanks,
Chris Brenna
I wish to use a cell's value to define the name in the name box. I'
not sure if this is possible or if I'm just getting the syntax wrong.
I'm trying to group 7 days (cells) and then have Excel keep th
grouping as I copy them for subsequent weeks. I don't want to manuall
keep naming the groups as new weeks are added.
Example in the name box:
INDIRECT("week" & $A1)
where A1, A2, A3, etc. will contain the sequencial values 1, 2, 3, etc
Essentially, the names would end up being week1, week2, week3, etc.
I've just managed to Indirect much of the other functions of m
workbook and this seems to be the last part to fix.
Thanks,
Chris Brenna