Hello code experts
With the help of a code, I am trying to create a copy of 2A sheet with the name Portal with some editing. After a copy of 2A is created, the changes required in the new sheet are
1. Column I replace ??? with the numbers above at each Invoice number -Total as shown in the Portal sheet
or
Enter the combined rate of each row above,in column I in each row which contains -Total in column C
2. In the new sheet delete all the rows which do not contain -Total in the column C.
3. Remove the bold format from the sheet
4. Rename the new created sheet as Portal.
I have shared both the sheets 2A (Original) and the expected result sheet (Portal) in the workbook.
Thank you in advance.
Bookmarks