Is it possible to create a dynamic table ?

[exceluser]

Is it possible to create a dynamic table that automatically expands or
contracts vertically based on the data source the table was created
from ?



Exceluser

 

[Jim Cone]

xl2003 has the built-in "List".
xl2007 has the built-in "Table"
(the two are nearly identical)

A named range can be dynamic if it created using a formula...
=OFFSET('MyWorkbookName.xls'!NamedCell,0,0,COUNTA(SheetName!$A:$A)-1,1)
--
Jim Cone
Portland, Oregon USA
http://www.mediafire.com/PrimitiveSoftware
(commercial and free excel programs)
..
..
..

"exceluser" <[email protected]>
wrote in message
Is it possible to create a dynamic table that automatically expands or
contracts vertically based on the data source the table was created
from ?



Exceluser

 

[exceluser]

Jim,

Thanks for the response.

I should have made the question clearer.

After you create a table in Excel 2007 and then click on the Resize
Table button, the table's address range is fixed.

If the data source the table is based on is dynamic (i.e., rows are
added or removed), the table will not update its address range.

What I was trying to do is come up with a formula to put in the
Resize Table's field that would allow the table to automatically
expand or contract depending on changes to the data's source.

Any ideas ?




Exceluser

 

[Roger Govier]

Hi
Whilst the range looks to be fixed when you create or resize it, the fact
that it has been created as a Table is known by Excel 2007 and 2010, and its
dimensions will automatically expand or contract as you add or remove data.

--

Regards
Roger Govier

Jim,

Thanks for the response.

I should have made the question clearer.

After you create a table in Excel 2007 and then click on the Resize
Table button, the table's address range is fixed.

If the data source the table is based on is dynamic (i.e., rows are
added or removed), the table will not update its address range.

What I was trying to do is come up with a formula to put in the
Resize Table's field that would allow the table to automatically
expand or contract depending on changes to the data's source.

Any ideas ?




Exceluser

__________ Information from ESET Smart Security, version of virus
signature database 5526 (20101013) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 5526 (20101013) __________

The message was checked by ESET Smart Security.

http://www.eset.com

 

[exceluser]

Roger,

Thanks for the reply.

I should have mentioned I was using structured references.

Since the data source the table is based on expands and contracts,
the number of rows in the table are incorrect.

For example, if the data source contracts (rows are removed), the
structured references will return zeros.

If the data source expands (rows are added), rows are not added to
the table.

In the meantime, I ended up creating a cell that reports if the
number of rows in the table doesn't match that of the data source.



Exceluser