Does anyone know how to create a template that self adjusts the formula ranges. For example I have tested my template that I create using one of my workbooks. My workbook has formulas from column B Row 600 to Column H to Row 615, when I copy data that has 700 rows the formula does not adjust. Is there a way to get it to adjust the range using the workbook template?
WorkBook Template
- Thread starter NoelNoel
- Start date
Awesome Wally
Member
Did you try converting your data range to a table?
No have not tried that. Thanks for the information.
David Evans
Active Member
There are other ways of creating Dynamic Ranges, but if the Table trick works for you, its by far the most straightforward - you will have to adapt to Structured References as they are named, but that's a small price to pay - actually they are great - they are literal, as opposed to a bunch of cell references