Forum Discussion
Create Dynamic range from another dynamic range
I have a schedule availability calendar where the top row is the times and the first column is the name of the members in the group. This calendar has a sheet for each day of the week and a sheet wh...
MemberCount is a dynamic named range.
I didn't explain what I am trying to do very well, so to clarify. I want to create a new Dynamic named range in a specific column and have it automatically populated with the data in MemberCount.
I thought it could possibly be done in the formula that defines the name. If so, how would I change the formula below to reference MemberCount and automatically pull in the data?
=INDEX($A:$A,COUNTA($A:$A))
- It's the same thing. You don't have to use the Sheetx! reference if the range is on the same sheet as the formulas you will be using it in. I will be using the sheet reference as the MemberCount range will be on sheet 8.