VBA button that insert copied range of cells below and shift everything else down

[Rubensho]

Hi, I would kindly ask for help to accomplish this instructions using VBA:

I already looked everywhere and no luck, any help will be really grateful.

 

[davesexcel]

Try out your macro recorder, then update your post with the code, somebody will be able to help with it.

 

[Rubensho]

Try out your macro recorder, then update your post with the code, somebody will be able to help with it.

Omg.. Using macro recorder I solve this pretty easily.. sorry I'm newbie using VBA and macros, and thanks a lot for your reply it worked exactly how I needed.

 

[My Aswer Is This]

Omg.. Using macro recorder I solve this pretty easily.. sorry I'm newbie using VBA and macros, and thanks a lot for your reply it worked exactly how I needed.

Show us the code.

 

[Rubensho]

Show us the code.

It does not do exactly what I requested in the pictures but it get the job done, now instead of inserting values below it does insert on A10 and then shift down.
also now I copy that table from another worksheet and works great:
Sub Agregar()
'
' Agregar Macro
'

'
Sheets("Data").Select
Rows("1:6").Select
Selection.Copy
Sheets("ENTREV. INIC. Y EST DE SIT 1").Select
Rows("10:10").Select
Selection.Insert Shift:=xlDown
End Sub