Update range

[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

 

[JE McGimpsey]

Take a look here:

http://cpearson.com/excel/excelF.htm#DynamicRanges

 

[Frank Kabel]

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