Name Range with using Data Form

[Grey]

I first created a variable with A11, four columns with named variable
Data. How to expand this Data range to A12 after using the DataForm to add
one row data in the worksheet?? The same, the Data range should be A13
when adding one more data row...

million thanks

 

[Frank Kabel]

Hi
use the following formula in the name definition dialog
=OFFSET($A$1:$D$1,0,0,COUNTA($A:$A))