Hi, I have an issue where the formulas in a Summary table becomes corrupt if I add or delete rows in the main data table. Is there VBA code to stop this happening? I have attached an example file (If you add a row in the main log table.....the summary table becomes corrupt)...... Hope this makes sense!!Test.xlsm