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 RABBITB1 shifts down in A2 and C1 shifts down in A3 and so on for n columns...

appreciate help on this. many thanks!!

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))

Ask Your Question

Weekly Poll