yousafkhan1976
New Member
- Joined
- Feb 24, 2019
- Messages
- 4
Hi Everyone, my first post here!
I have searched and tried many different ways to create a dynamic named range where the starting cell column remains the same but the row can move depending on the number of rows inserted above. I thought the following may work, but even though if the formula is used in a cell I get the correct range defined "$A48:$AF83", but when I put the same formula in the "Refers To:" section of the named range, it does not work.
="$A"&((MATCH("Staff Effort, Hours",Resources!A:A,0)+1)&":$"&(SUBSTITUTE(ADDRESS(1,COUNTA(Resources!45:45),4),1,""))&((MATCH("LastRowHours",Resources!A:A,0))-1))
Any help would be greatly appreciated.
I have searched and tried many different ways to create a dynamic named range where the starting cell column remains the same but the row can move depending on the number of rows inserted above. I thought the following may work, but even though if the formula is used in a cell I get the correct range defined "$A48:$AF83", but when I put the same formula in the "Refers To:" section of the named range, it does not work.
="$A"&((MATCH("Staff Effort, Hours",Resources!A:A,0)+1)&":$"&(SUBSTITUTE(ADDRESS(1,COUNTA(Resources!45:45),4),1,""))&((MATCH("LastRowHours",Resources!A:A,0))-1))
Any help would be greatly appreciated.
