VBa code to delete column data and resize table

[Nirmall]

Hello friends,

have a workbook which has 2 worksheets.
1 is called "Packing List" and the other "Data".

Now in Sheet Packing List have used formulas in column B, C, D to fetch data from sheet Data based on the value in ColumnA.

Now would like to create a macro that will delete the data from column A in sheet "packing List", and resize the table as well.

Please note that formula in column B,C and D should not be deleted atleast for row2,

Also the data can be more that 100 rows, cant tell exact figure now.

Any help on the same please??

Regards

[kvsrinivasamurthy]

Now would like to create a macro that will delete the data from column A in sheet "packing List", and resize the table as well.

Column A should be delete or contents are to be erased. Resize for how many columns.
Instead of many formulas, formula in B2 to be copied to full range.

Please Login or Register  to view this content.

[Nirmall]

Column A should be delete or contents are to be erased. Resize for how many columns.
Instead of many formulas, formula in B2 to be copied to full range.

Please Login or Register  to view this content.

Contents of column A to be erased
And table to be resized

No. of columns will always remain the same as in the workshet Packing list

[kvsrinivasamurthy]

Criteria for number of rows to be resized.

[Nirmall]

Criteria for number of rows to be resized.

Depends on how many rows are filled