Update range

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I have a sheet that uses a drop down box which contains data in a range in
another workbook.

I occasionally have to add entries to this range and then have to go to
"Insert, Name, Define", etc., to adjust the range.

How can I make the range increase automatically please?

Thanks

Mike
 
For the name definition use the following formula (combination ofOFFSET
and COUNTA):
=OFFSET('Data Range'!$A$1,0,0,COUNTA('Data Range'!$A:$A)-1,1)

HTH
Frank
 
Back
Top