Dynamic Ranges & Invisible Offset
 

I am comfortable working with Dynamic Ranges that expand and contract
automatically, based on =offset()

Example he
http://www.ozgrid.com/Excel/DynamicRanges.htm


I am trying to figure out another way to do this. I am working with a model
that someone else designed. He is no longer with the company so I cant ask
him how he crated this dynamic offset, but it works on the same principal as
the =offset() function mentioned above. All I can see is a blue border
around the list of data that is being offset from. Also, there is a small
blue asterisks in the lower left hand corner of the list€¦this seems to
indicate the last row (which is blank) of this otherwise invisible offset
feature. Can anyone shed some light on this topic for me?

Regards,
Ryan---


--
RyGuy

Dynamic Ranges & Invisible Offset
 

this is called a LIST and was a new feature added in Excel 2003.

With this area selected,
In the menus, go to Data=List and you should have a bunch of choices.

if you want to create one, create a table like you would use for Autofilter
and select it, then do Data=List=Create List

--
Regards,
Tom Ogilvy


"ryguy7272" wrote:

I am comfortable working with Dynamic Ranges that expand and contract
automatically, based on =offset()

Example he
http://www.ozgrid.com/Excel/DynamicRanges.htm


I am trying to figure out another way to do this. I am working with a model
that someone else designed. He is no longer with the company so I cant ask
him how he crated this dynamic offset, but it works on the same principal as
the =offset() function mentioned above. All I can see is a blue border
around the list of data that is being offset from. Also, there is a small
blue asterisks in the lower left hand corner of the list€¦this seems to
indicate the last row (which is blank) of this otherwise invisible offset
feature. Can anyone shed some light on this topic for me?

Regards,
Ryan---


--
RyGuy

Dynamic Ranges & Invisible Offset
 

Whoa! You are correct! I have never used this feature before, but I will be
researching it shortly, and will almost certainly be using it in the very
near future.
Thanks so much!
Ryan---


--
RyGuy


"Tom Ogilvy" wrote:

this is called a LIST and was a new feature added in Excel 2003.

With this area selected,
In the menus, go to Data=List and you should have a bunch of choices.

if you want to create one, create a table like you would use for Autofilter
and select it, then do Data=List=Create List

--
Regards,
Tom Ogilvy


"ryguy7272" wrote:

I am comfortable working with Dynamic Ranges that expand and contract
automatically, based on =offset()

Example he
http://www.ozgrid.com/Excel/DynamicRanges.htm


I am trying to figure out another way to do this. I am working with a model
that someone else designed. He is no longer with the company so I cant ask
him how he crated this dynamic offset, but it works on the same principal as
the =offset() function mentioned above. All I can see is a blue border
around the list of data that is being offset from. Also, there is a small
blue asterisks in the lower left hand corner of the list€¦this seems to
indicate the last row (which is blank) of this otherwise invisible offset
feature. Can anyone shed some light on this topic for me?

Regards,
Ryan---


--
RyGuy