Excel Table Copy Paste Sheet

[Mcook13]

Hello Excel Wizards,

I have several formulas that reference another sheet in my workbook. I routinely receive an email from my customer with their worksheet in an attachment. So to update my sheet, I simply copy and paste the entire sheet. I did it this way because the rows can vary between 200 rows to 100 rows.

However I needed to covert my sheet to a table so that it would be dynamic for my formulas, but now when I copy and paste the entire sheet as before, my table went from 100 rows for the range of the table to the entire sheet (all 1 million) being part of the table.

How do I work around this?

 

[jasonb75]

Only copy the table not the whole sheet.

Copying the entire sheet is a bad practice that should be avoided, it makes the files much bigger than they need to be. The problem of 1 million rows being copied has always been there, it merely stands out more with a table.