Name a dynamic Range
I am currently using the following formula to name a range of data in a list
whic is regularly updated.
=Offset(Sheet1!$A$1,0,0,counta(Sheet1!$A:$A),35)
I wish to create another range of data from the same sheet which contains 35
columns - I want the range to consist only of the rows in which column "U"
is blank.
I would also like the range to be dynamic so it updates as new rows are added.
thanks for your help.
Regards
Mark
|