Add a new row when two tables are next to each other but copied from another sheet

CSWorker

New Member
Joined
Jun 17, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
  2. Web
I have a workbook with a tab for each of the different sites I manage with all the information about the compliance actions taken across the year. Date, notification number, name, action taken etc.
Then the first tab is a brief overview of them all grouped by site so that if someone needs basic information but not the specific confidential information then I can turn it into a PDF and provide that instead. So I've made the sections I'm happy to go onto the overview sheet into a 'table' in each site sheet and I've managed to figure out how to copy the table onto the overview sheet. The problem is that when I add data in a site's tab, it folds it into the table (which is what I want) but on the overview sheet it looks like it's trying to write over the service table below and then comes up with a spill error.
My question is, is there a way to make the overview sheet automatically add a row when I add information to a site sheet so that the data isn't trying to write over another table?

Thanks heaps in advance.
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Forum statistics

Threads
1,141,073
Messages
5,704,138
Members
421,328
Latest member
mippy

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top