Macro to Insert Row, Copy & Paste all-in-1

[donkeybusiness]

Hi,

I have to do a lot of entries which looks like this :-

Row 1 : AAAAAAA (Data in several columns)
Row 2 : BBBBBBB
Row 3 : CCCCCCC

I need to insert 1 row (sometimes 2 rows) directly below a selected tow (eg. Row 1), and then copy everything in row 1 & pasted to the newly created row(s).
So the output will be something like this :-

Row 1 : AAAAAAA
Row 2 : AAAAAAA
Row 3 : AAAAAAA
Row 4 : BBBBBBB
Row 5 : BBBBBBB
Row 6 : CCCCCCC

Currently, I manually insert row, copy & paste, repeat repeat & I have a lot of rows to handle.
Would appreciate if anyone could help me ease my task.
Thanks!

[Artik_PL]

Please Login or Register  to view this content.

Artik

[donkeybusiness]

Amazing!
Just 1 more question, can this be used with a keyboard shortcut ?

[Artik_PL]

Naturally.
In Macro window select [Options] button.

Artik

[donkeybusiness]

Great stuff!
Many thanks!

[donkeybusiness]

Sorry, it appears that I'm unable to 'Undo' the action after running the Macro, any help ?

[jolivanes]

John Walkenbach has a solution here.

http://j-walk.com/ss/excel/tips/tip23.htm