Automaticly insert rows in more sheets

**Laki024** · 04-01-2014, 04:51 AM

When I insert 1 rows in first sheet, I want to insert automaticly 10 rows in second sheet, and 1 rows in sheet3, sheet4, sheet 5, sheet 6, sheet 7, sheet 8, sheet 9, sheet 10, sheet 11, sheet 12, sheet 13, sheet 14, sheet 15, sheet 16, sheet 17, sheet 18, sheet 19 and sheet 20.

In attachemnt I mark this red colour.

**p24leclerc** · 04-01-2014, 02:58 PM

Where do you want to insert those rows? At the first non-empty row in column A? Or else?

**Laki024** · 04-01-2014, 04:53 PM

if I insert row in sheet1, I want to automatic insert full row in more sheets, ( 10 rows in sheet2 , and 1 row in sheet3 etc till sheet20 ).

I mark what I want in red colour. View attachment.

**p24leclerc** · 04-01-2014, 07:36 PM

here is a way of doing this:
Create a named range "rowCheck" pointing at a cell well below your regular cells activity but not the last row though. Put the row number into that cell.
Now place the following macro into your sheet1 code in VBA.
And you're done. Every time you'll insert a row in sheet1, rows will be added in all the other sheets.

Please Login or Register  to view this content.

You'll have to rename your workbook to .xlsm extension so it accepts macros.

**Laki024** · 04-02-2014, 07:11 AM

Ok, thank you.

I try to insert this code in VBA, but not sucessfull. I never work with macro and VBA codes in excell, just used fx formula.

Would you be so kind as to insert the code already in excell, and attach file.