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.
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.