Dynamic Name Range using OFFSET function for to expand the list as and when required

Dear Friends,

When I created a named range with offset function for dynamic list with the following formula using OFFSET function, it was not selecting as I required:

Please Login or Register  to view this content.

The data starts from row 3 as follows:

Please Login or Register  to view this content.

I would like to make dynamic name list for Code column. When I applied the above OFFSET formula in named range, the list consist of both "Code" & "Empty" also.

Similarly, I would like to create more dynamic ranges in the same sheet for various columns.

Kindly suggest how to make a dynamic range in which I can have only the data available in the related column.

yours,
acsishere.

Try changing it to:

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

There's a macro that will do this at http://www.excelforum.com/tips-and-t...ic-ranges.html