I was hoping this wouldn't happen?
The problem is I have formulas in row 13 that looks at a range in the Table below. Every 5 secs the contents of row 15 are pasted to row 18 of a Table and the Table expands down a row to accomodate. Take cell O13 for example. When the Table was blank the COUNTIFS formula referred to ranges O$18:O18,K$18:K18. As the Table is populated despite the '$" absolute reference, the range moves down instead of expanding. At present in the screen capture there has been 32 5sec pastes carried out, and the range is now O$50:O50,K$50:K50 instead of O$18:O50,K$18:K50.
Is there a way round this? Cheers