Forum Discussion
Automatically resize a table based on the source data
I have a table named `Table1` which is referenced by many cells in the workbook (i.e., target file). The data in `Table1` is regularly manually copy-pasted from a source file: in the source file,...
You could just highlight all but 1 or 2 rows of the table, right click and select Delete table rows before you paste in the data.
That said, I would highly recommend you consider using Power Query or the Get and Transform to get the data from the external file. When the data in the external file changes you just refresh all and it will get updated. You can even use a cell in the worksheet to define the name/location of that file (for that I recommend you search for a tutorial to help).