Hi,
I have a question about a dynamic named range. I use it for the source of my pivot table. Essentially, my workbook is used for managing stocks. Each week I add a new data set.
At the bottom of each data set is two summary rows. For example, week ending 7/22, the summary rows take up cells: B128:T129. Next week, week ending 7/29, the summary rows take up cells: B161: T162. I need to create a dynamic named range which selects these ranges and continues to select them as I add more weeks.
Right now I have the code:
=INDIRECT("Long!$B$"&(COUNTA(Long!$B:$B)-1)&":$T$"&COUNTA(Long!$B:$B)) which selects B161:T162, but will not select previous ranges or future ranges.
Is there a way to have this dynamic named range select these other ranges?
Thanks I really appreciate any help here,
Mark
I have a question about a dynamic named range. I use it for the source of my pivot table. Essentially, my workbook is used for managing stocks. Each week I add a new data set.
At the bottom of each data set is two summary rows. For example, week ending 7/22, the summary rows take up cells: B128:T129. Next week, week ending 7/29, the summary rows take up cells: B161: T162. I need to create a dynamic named range which selects these ranges and continues to select them as I add more weeks.
Right now I have the code:
=INDIRECT("Long!$B$"&(COUNTA(Long!$B:$B)-1)&":$T$"&COUNTA(Long!$B:$B)) which selects B161:T162, but will not select previous ranges or future ranges.
Is there a way to have this dynamic named range select these other ranges?
Thanks I really appreciate any help here,
Mark
