You can use Dynamic named range, here is a link,

http://blog.contextures.com/archives...dynamic-range/

You can Google it for more