Table Size - Automatic Row Number

**ionelz** · 01-15-2018, 06:48 PM

I have a Table1 in Sheet1 (with N1 numbers of Rows in Table1, N1 created at Table creation) and Sheet2 with a numbers of Rows
I want to : Count Number of Rows with value from Sheet2 (say N2) and Automatic adjust Table 1 numbers of rows to N2+5

**jeffreybrown** · 01-15-2018, 08:19 PM

This is a very confusing description, well, at least to me. Do you have a sample workbook you can post with a before and after?

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

**ionelz** · 01-15-2018, 08:48 PM

Done, I have attached with better explanation I guess

**ionelz** · 01-15-2018, 08:52 PM

So COUNT Column C with values and Make Table numbers of rows = Count so Column C it fit in Table

**jeffreybrown** · 01-15-2018, 08:53 PM

Highlight C1:C7 >> copy >> paste on A2

Table will auto adjust down to the A7

**ionelz** · 01-15-2018, 09:04 PM

It will not
If numbers of rows in Table is bigger then the number of rows in column c, table will not adjust "up"
That why I like table number of rows to be variable to number of rows in column c

**jeffreybrown** · 01-16-2018, 09:45 AM

Seems like this is defeating the purpose of a Table in Excel which is meant to grow as you add new data or decrease as you remove data. Not sure how you end up with empty rows when using a Table.

Anyway, only way I can think to do it would be with code.

Please Login or Register  to view this content.

Say your table spanned from A1 to A21 and in column C you have 7 values. This code would remove the waste from A21 to A9.

**Kumaster** · 01-16-2018, 10:24 AM

Hi,

I don't think you need VBA for this.
Check whether the option "Include new rows and Columns in table" is checked.
Location of the option: Excel options >> Proofing >> "AutoCorrect Options..." >> "AutoFormat as you type" >> Second option

If checked, you should be able to paste more cells and the table will adjust its size.

Regards

Table Size - Automatic Row Number

LinkBack

Thread Tools

Rate This Thread

Display

Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Re: Table Size - Automatic Row Number

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Number of Selected Items in Listbox Determine Size of Table

[SOLVED] Automatic next table number from 1 to 10? once other players complate the scores results

Pie : automatic scale/size

Is there a way to adjust many cell size(automatic adjustment) at once?

make an automatic new table in seperate tab dependent on a number or 0 being entered

Auto size a pivot table to a page size

[SOLVED] ehhh, is there a way to automatic size the x-axis of a chart

Bookmarks

Bookmarks

Posting Permissions