Duplicating rows within a sheet using vba

akshatk1991

New Member
Joined
May 6, 2013
Messages
13
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!
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

ChrisR

Well-known Member
Joined
Dec 21, 2012
Messages
848
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

New Member
Joined
May 6, 2013
Messages
13
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?
 

Forum statistics

Threads
1,136,329
Messages
5,675,142
Members
419,551
Latest member
thangxpm

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