-
Created 39 minutes ago
by sh iva
i have a macro recording to insert a row, copy paste values in the row in Sheet 2. This saved data in sheet 2 is used through data validation. The macro works fine to record the data however when using the data with the standard $A$2:$A$1000 changes to $A$3:$1001 and having identified i opted for =OFFSET(sheet2!$A$2,0,0,COUNTA(sheet2!$A:$A),1) the formula changes to =OFFSET(sheet2!$A$3,0,0,COUNTA(sheet2!$A:$A),1)