Macro - how to add 4 cells from the row above + lower 4 cells from another row - and copy the formulas of the first 3 cells?

[filipealves1973]

Hello all

Thought i was good at excel.... but this is a bit dauting for me.

So - having this table:

2001 um 100 10 10
2002 dois 200 20 20
2003 tres 300 30 30

I need a macro that allows me to do this:

2001 um 100 10 10
um 100 10 10
2002 dois 200 20 20
2003 tres 300 30 30

Basically:
- Add 4 cells down
- copy the 4 cells from the row above
- keep the formulas and format

and to be able to do this with a keystroke...

Being honest - i know that this needs to be done with VBA.... But still do ideia...

Thanks to all
Filipe

 

[footoo]

• Do you want to do for every row of original data?
• Do you want to insert a whole new row or just move the data in columns A:E down?
• You want to copy B1:E1 and paste to A2:D2. Correct?
• How many rows of data do you have?
• In which row does the data start