resize table

Hi everyone, after much searching I found this forum. Really need your help. I have a workbook consisting of two sheets. Sheet 2 - data that comes from a filtered table. basically each cell has a formula that pulls values from another table. It could be 1 row, or it could be 100 rows...

I'm working with a dynamic table that populates names based on the given weeks data. I have a macro that refreshes and sorts the data as needed but am currently working with the .Resize Range() function to adjust the table based on how the rows populate. Note: "Login" cells populate based on an...

Hello Everyone, I am working on gathering some data on jobs that require very little assembly time and I am writing some script to automate that. In an effort to speed things up I am trying to resize the destination table to match the size of the data prior to copying. However, something is...

Hello, I have a table inside my excel document. The table is pretty large, and has bounds/data range of ($J$1:$BN$3073). I am trying to record/write a macro that will 1. Find the end/bottom of this table 2. Copy the 12 rows that are at the bottom of the table 3. Paste/insert...

Novice in need of guidance! I run a macro that copies all cells with unique text from a separate work sheet and pastes them in the first column of a table. As this table has a load of formulas worked out using this column as a reference, I want the table to automatically extend to include the...

Yesterday, both igold & Akuini were very generous in assisting me with figuring out how to code something. We were able to figure it out (thank you again!!). Here is the thread: Push Down Rows However, now I am up against a different issue, but involving the same piece of code. The code...

I can select a table and subsequently navigate in the ribbon to Design->Properties->Resize Table but cannot use the small L bracket in the bottom righthand corner to do any resizing. The bracket exists but isn't selectable. As far as I've been able to tell it's only on one worksheet within a...

Hi, I have a table: wrksht.ListObjects("DataTable1") , its table range is A1: X2000. All cells have data validation pop instructions on how to correctly enter data into each cell. After the table is populated by the user i want to re-size the table based on a lastrow variable identifying...

I need to run a macro to delete all the rows (except for the first 2) in a table. The table is named "Table1". The problem is the tables size is always different. Is there a way in VBA where I can resize the table to the original size? Any help with VBA code would appreciated. Thanks in advance. :)