Change size of Excel Data Table, dynamically

Is there a way to increase the size of the data table dynamically?

I'm not too sure what that means. It could be that lists or dynamic named ranges are what you are looking for, but you'll have to be more specific about what you're doing and what you'd like to do.

So cell A1 = 3

My tables is
xx Data
1 5%
2 8%
3 12%


Cell A1 changes to 4...

My table is
xx Data
1 5%
2 8%
3 12%
4 7%

Question for all of you in excel – I have a couple sheets linked to one sheet. Now on the one sheet I want to insert another line to make a title but it causes all the info to shift down, and by doing this the links don’t correspond to the appropriate sheets anymore. It’s taken me a while to match up the links so I want to avoid doing this. Do you know how I can add a row to the one sheet without messing up the rest of the data?

Not quite sure how to do that

Originally Posted by joshjpang

So cell A1 = 3

My tables is
xx Data
1 5%
2 8%
3 12%


Cell A1 changes to 4...

My table is
xx Data
1 5%
2 8%
3 12%
4 7%

Sorry, I still don't get it. Maybe you should attach an example workbook. I looks to me like you just want to display in cell A1 the size of the data table, e.g., how many rows it is. That would probably just be a simple Count or Counta statement, but you'd need to know where the data table is.

There are plenty examples of count and counta on the forums if that is in fact what you are trying to do.

Or maybe he manually enters a value in cell A1 and a list of random numbers is generated down column 'A' for as many rows as the value in A1?

Time will tell...

I think he wants to change the number of rows in a table based on A2 cell value...I don't know if that's possible. All I know is that you can copy a formula dynamically into as many rows you want using INDEX, ROWS, and MATCH functions. Watch the video, I think it might help.

http://www.youtube.com/watch?v=6bGKhbUYOas