Posts by Mumps

    If you want to delete only row 8 from column B to column V try:

    Code
    Sub DeleteRow()
        Rows(8).Delete
    End Sub

    If you want to delete all the rows in your table, try:

    Code
    Sub DeleteRows()
        ActiveSheet.ListObjects("tabela1").DataBodyRange.Delete
    End Sub

    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.

    Could you attach a copy of your file including your current macros? 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.

    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.