Hi All
I apologise if this has already been covered elsewhere, I've been having a scour and been unable to find anything that fits my problem so hoping one of you amazing excel wizards can help...
I have a Workbook with multiple sheets, each has a table containing the same items. They all reference back through various lookups toa master spreadsheet which is all working fine. They also have to reference each other and the easiest way to do that is for them all to have the same items in, for various reasons. I'm trying to find a way that I can insert a row into the master spreadsheet and for that propagate through the rest of the workbook adding the inserted row into the same place in all the tables. This doesn't necessarily need to happen automatically, it could be via an "update" macro for example.
To give a rough example of what I am working with (table names, sheet names, and items within tables changed to be more relatable):
Let's say I have 11 sheets, a master and then shop 1 thru shop 10.
Each sheet has a range formatted as a table, each table is named "tbl_master", "tbl_shop1" etc etc
The items in each of the tables are all the same and in the same order like below.
All tables start in the same place, e.g. A6
<tbody>
</tbody>
I want to then add in a row on tbl_master below FA (Apple) and populate the first 2 common columns with FP (Pear) and for tbl_shop1 thru tbl_shop10 to also receive the update with no data added to columns C (Qty In) and D (Qty out). Ideally these columns would behave like tables usually do and assume the formulae from the rest of the column.
If there is anything I have failed to explain correctly then I can answer any questions to help me get to a solution for this.
Many thanks in advance for all of your help.
Dan
I apologise if this has already been covered elsewhere, I've been having a scour and been unable to find anything that fits my problem so hoping one of you amazing excel wizards can help...
I have a Workbook with multiple sheets, each has a table containing the same items. They all reference back through various lookups toa master spreadsheet which is all working fine. They also have to reference each other and the easiest way to do that is for them all to have the same items in, for various reasons. I'm trying to find a way that I can insert a row into the master spreadsheet and for that propagate through the rest of the workbook adding the inserted row into the same place in all the tables. This doesn't necessarily need to happen automatically, it could be via an "update" macro for example.
To give a rough example of what I am working with (table names, sheet names, and items within tables changed to be more relatable):
Let's say I have 11 sheets, a master and then shop 1 thru shop 10.
Each sheet has a range formatted as a table, each table is named "tbl_master", "tbl_shop1" etc etc
The items in each of the tables are all the same and in the same order like below.
All tables start in the same place, e.g. A6
| Code | Description | Qty In | Qty Out |
| FA | Apple | 10 | 0 |
| FO | Orange | 5 | 5 |
| FB | Banana | 11 | 2 |
| FG | Grapes | 6 | 1 |
| VC | Carrot | 10 | 0 |
| VP | Potato | 100 | 10 |
| VL | Lettuce | 15 | 1 |
| VT | Tomato | 30 | 5 |
| VO | Onion | 12 | 12 |
<tbody>
</tbody>
I want to then add in a row on tbl_master below FA (Apple) and populate the first 2 common columns with FP (Pear) and for tbl_shop1 thru tbl_shop10 to also receive the update with no data added to columns C (Qty In) and D (Qty out). Ideally these columns would behave like tables usually do and assume the formulae from the rest of the column.
If there is anything I have failed to explain correctly then I can answer any questions to help me get to a solution for this.
Many thanks in advance for all of your help.
Dan
