copy formulae across dynamic range
I need to create ranges of formulae which are dynamic in both directions – i.e. across an unknown number of rows (years) and columns (properties on which rent has to be calculated). The raw data (initial rents & start years for each property) will be exported from a database to a dynamic named range. in a separate range I then want to calculate the annual rent for a number of years for each property. Each time the data is exported, the number of properties (columns) and rows (years) will be different. How can I get the formulae in the rent calculation range to fill dynamically to the right number of rows & columns?
copy formulae across dynamic range
I am not sure about structure of your data, but I guess you should convert you table do Data Table. Click anwyhere in table, Insert, Data Table. Create formulas and it should extend when you add new data.