Duplicating rows within a sheet using vba

[akshatk1991]

Hey,

So i have a set table containing data for a country, and i have the same table with data for other countries in tables on one sheet. My problem is that if i add a row to the first table, i have to manually add this row to the 14 other tables below it. The number of rows per table and all the data is all standardized. Is there a way to create a macro which will allow me to add a row to all tables when i change the first table? Cheers!

 

[ChrisR]

Can you post up your data? Much easier to give an answer if we can see at least two of the tables you are referring to, distance between them etc etc.

 

[akshatk1991]

Alright, cant seem to post the table but it follows this format

ColumnB ColumnC
India Jan Feb March and so on
Production 2
Import 2
Export 2
Demand 2
Supply 2
Inventory 2

Now this is repeated for china, malaysia, indonesia etc. Say i want to add a row for inventory changes for example, and i add it for india, i would have to manually add the row to china, malaysia etc. which i have been doing so far. Is there a way to do so via vba?