Hello.
I have data on Sheet1 in blocks of rows (A3->A40, A44->A81, A85->A122, A126->163, A167->A204) and in Sheet2 I have formulas on those data
If I need to add a block of rows to Sheet1 (I can choose if in the beginning, in the middle or at the end) is there a way for having those new rows included automatically in the formulas in Sheet2?
I've tried adding a block of rows in the middle of Sheet1 but then the formula in Sheet2 was ignoring those new rows...
I'm attaching an example file.
Thanks!
Bookmarks