Setting a dynamic Named range

Hi,

I am looking for a way to make a named range that referes to the latest entrys in a column until a row is blank.

Example

12/32/3034 Social community 4922 3999 3399
12/93/3432 Help community 3233 3422 2342

12/34/3234 Vage community 2342 2342 3424

I want the range to start at the bottem and only selects "vage community" and then stops because there is a white row.

Thanks so much!!

Assuming the named range would be columns A:E and the row would be the "last row with data in it looking up column A", this named range formula would do that:

=OFFSET(INDEX($A$1:$A$1000, MATCH("zzzz*", $A$1:$A$1000, 1)),,,,5)