Hi All,
I've got the following formula on sheet1,
the "Active" sheeet is where the data is.Please Login or Register to view this content.
On the active sheet is a macro that creates a row on row9, thereby pushing the data down the sheet, and hence changes the above formula to start
calculating form row 10 !!
can anyone help so the above formula, no matter what, always sums from row 9
Bookmarks