Posts by Mumps

    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.

    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?

    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.

    Could you attach a copy of your file including any macros you are currently using? It would be easier to see how your data is organized and to test possible solutions. Include a detailed explanation of which fields are mandatory, referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

    Try:

    Try:

    Change the sheet names to suit your needs.

    Try:

    Try:

    No problem. Sometimes it takes time to change and test a macro. Also, sometimes Forum members are not online to see your request. Did the macro work as you requested?

    Try:

    Please be patient when waiting for a reply.

    Try:

    Try:

    Could you attach a copy of your file? It would be easier to see how your data is organized and to test possible solutions. Include a detailed explanation

    of what you want to do using a few examples from your data and referring to specific cells, rows, columns and sheets. De-sensitize the data if necessary.

    There would be a couple of issues if you simply copied the rows from market data to template data. First, there are more columns of data in market data than in template data and second, there are some column headers in market data that do not exist in template data. Please clarify in detail. It would be helpful if you could manually create another sheet that shows your desired result including how you want the cells formatted and then attach an updated file.

    Try:

    Please note that you have misspelled the sheet name "Not Awarded" in your file.