Hi all,

The following formula i use to name a range so when ever i add data to
column A the range is automatically adjusted.

=OFFSET(Daily!$A$1,1,0,COUNTA(Daily!$A:$A)-1)

now how I cud I modify this formula to get a dynamic range on Row 1
($1:$1)

thanks