macro to insert 2 rows after every single row

November 6, 2010 at 07:51:34
Specs: Windows Vista
Hi

I have a similar question to what was posted earlier on.
after inserting the 2 rows, i need to also shift the data down to the 2 rows.

A B C
1 CAT DOG RABBIT
2 DOG
3 RABBIT

B1 shifts down in A2 and C1 shifts down in A3 and so on for n columns...

appreciate help on this. many thanks!!


See More: macro to insert 2 rows after every single row

Report •

#1
November 6, 2010 at 16:02:02
You don't need a macro.

Put this formula in D1 and drag it down:

=OFFSET(INDIRECT("A" & ROUNDUP(ROW()/3, 0)), 0, MOD(ROW()+2, 3))


Report •
Related Solutions


Ask Question