VBA macro of copy data from one excel to another template

    Hello all,



    Could you please support me in creating a copy-paste range of data from one sheet of an excel file to a new template sheet that needs to have the header above?

    I'm not very expert on the MACROS.

    I need to copy through an automated macro from the cell DG;DH;DI;DJ in the TEMP sheet in my excel (only the data that will have input) and paste it automatically when a macro button will be pushed to a new excel template that will have the defined headers named RPA PnL Offer Template. This information copied should be input to the respective cell starting at a2;b2;c2;d2 populating the data copied from the other excel template that should have the below view:


    A1 B1 C1 D1 E1

    Customer Account Number Group Name MSISDN New Tariff Plan Fixed monthly payment for Plan (VAT Inc.)
             
             
             


    Appreciate your help, please.



    Thank you!

    Ely

    Quote from ely80

    DG;DH;DI;DJ

    These columns in your file do not contain any data. It would be helpful if you could post a revised file with some data in those columns.

    Quote from ely80

    new excel template that will have the defined headers named RPA PnL Offer Template

    Does the macro have to create the new template? By "template" do you mean a new worksheet? Also, I don't understand where the headers (in red) come into play. Please clarify in detail. Does this new "template" have the headers below in row 1?

    Quote from ely80

    Customer Account Number
    Group Name
    MSISDN
    New Tariff Plan
    Fixed monthly payment for Plan (VAT Inc.)

    It would also help if you could include a manually created sheet in your revised workbook that shows the desired result based on the data in DG;DH;DI;DJ.

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

    My apologies. I just noticed that you marked the thread as "Resolved".

    You can say "THANK YOU" for help received by clicking the "Like" icon in the bottom right corner of the helper's post.
    Practice makes perfect. I am very far from perfect so I'm still practising.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login