Auto-size list question

[Evripos]

Hi.
I have a columnar list which I would like to make it dynamic based on a number I input. So, if I have let's say the following columnar list how can I make it become shorter or longer based solely on my numerical input?
Input n=10
[TABLE="width: 64"]
<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>[TR]
[TD="width: 64"]Car1[/TD]
[/TR]
[TR]
[TD]Car2[/TD]
[/TR]
[TR]
[TD]Car3[/TD]
[/TR]
[TR]
[TD]Car4[/TD]
[/TR]
[TR]
[TD]Car5[/TD]
[/TR]
[TR]
[TD]Car6[/TD]
[/TR]
[TR]
[TD]Car7[/TD]
[/TR]
[TR]
[TD]Car8[/TD]
[/TR]
[TR]
[TD]Car9
[/TD]
[/TR]
[TR]
[TD]Car10


[/TD]
[/TR]
</tbody>[/TABLE]
Thank you.

 

[BlueHornet]

The simplest way that I can imagine is by using a Table. In the table you create, your numerical entry would be in one column (I used Column A:A), and another column would have the formula: ="Car" & A2 (or whatever). Since it's a Table, the formula at B2 would be repeated row-by-row as entries are made below A2.

 

[pgc01]

Hi

Write in column A the list with the maximum number of elements that you need.
Write in B1 how many you want

Define the name:

Name: CarList
RefersTo: =OFFSET(A1,0,0,B1)

CarList will be your dynamic list.