VBA program to copy and paste cells from sheet2 to sheet1

Good Afternoon
I would like to implement a VBA program which basically copy and paste group of cells from sheet 2 to sheet1.
Very important; it should paste them in the cell I'm actually selecting and not in a specific cell.

The idea is to create a program able to add group cells (with fomulaes adn format included) in a specific cell, in order to speed up the normal process of copy and paste.

So the buttons should be able to copy and paste the block of cells of the second image (sheet2)


Is that possibile?

Let me know

Thank You in advance.

Andrea

Hi
have you taken a moment to read the yellow banner?

And while you are at it
Administrative Note:


although we value privacy as much as anyone else, it could be important that members have a rough idea of your location. You might in the future post questions which are bound to your regional settings.
So, please update your profile to something more precise then "asasd" ( country will suffice, no need to be more precise).
Thank you for helping us to help you

Administrative note

Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Thanks

And take a minute to read our forum rules

Done it, I'm sorry

Same code whatever the button, a beginner starter demonstration you must paste to the (Sheet1) worksheet module :

PHP Code: 

Sub Demo1()
    Dim V, Rg As Range
        V = Application.Caller:   If IsError(V) Then Exit Sub
    Set Rg = Sheet2.UsedRange.Find(Me.Shapes(V).TextFrame.Characters.Caption & "*", , xlValues, xlWhole, xlByRows)
     If Rg Is Nothing Then Beep: Exit Sub
        Rg.CurrentRegion.Copy ActiveCell
    Set Rg = Nothing
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !