Excel 2010 Tables / pasting new data

rgs694

New Member
Joined
Sep 18, 2013
Messages
30
I would like to use the Table feature in Excel 2010 to manage data as I paste updated data into the table on a weekly basis. The columns will always be set at 5. However, the rows will either increase or decrease from week to week.

Last week, I inserted my original table on to a 5 x 200 data set (5 Columns, 200 Rows). This week, I want to paste in a 5 x 150 data set into the same table. However, when I paste the updated data with 50 fewer rows into the table, the 50 extra rows of last week's data are still contained in the table. They are located below the updated 150 rows, and will give me inaccurate out put in other areas of the sheet where I'm using formulas on the data set.

Is there a way to have the table range adjust to newly pasted data automatically, without having to start a new table, or scroll all the way down to the table handle to adjust the height? Should the Offset function be entered in the Resize Table box, similar to how it's done with a Named List?

Thank you
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top