RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
Hello guys,
This is a continuation of the earlier query. There are multiple sheets in this workbook. They may range from minimum 3 to 11 sheets. In this case it is just 3 +1 sheets.
First of all, In the old code, I need to edit the code to display (As Per Portal),in the Edited Portal sheet under the column “Data from” as shown in the Edited portal sheet and fill it down.
Secondly, I want to copy data from sheets Journal, IGST and CGST column wise, and paste it to Edited Portal below the last empty row, under the same heading. (Except Line). Here, in the portal sheet “Data from” column I want the name of the sheet (As Per Journal), (As Per IGST), (As Per CGST), respectively.
Please note, Not all headings are available in sheets Journal, IGST and CGST. But whatever is available, to be posted.
After combining the sheets, Column B, below the “Portal” last row, to enter and fill down name “Tally”. The Line number to be filled down from Portal last number to the end as shown in the expected Result sheet.
Finally, I need to color all the values where the column B contains Portal from column A to M. Green color. Format the cells to Bold.
In future, your comments (explanation) on each line, will be very helpful to combine 10 or more sheets by editing the code.
Combine each Data as sheet name.xlsm
This is a continuation of the earlier query. There are multiple sheets in this workbook. They may range from minimum 3 to 11 sheets. In this case it is just 3 +1 sheets.
First of all, In the old code, I need to edit the code to display (As Per Portal),in the Edited Portal sheet under the column “Data from” as shown in the Edited portal sheet and fill it down.
Secondly, I want to copy data from sheets Journal, IGST and CGST column wise, and paste it to Edited Portal below the last empty row, under the same heading. (Except Line). Here, in the portal sheet “Data from” column I want the name of the sheet (As Per Journal), (As Per IGST), (As Per CGST), respectively.
Please note, Not all headings are available in sheets Journal, IGST and CGST. But whatever is available, to be posted.
After combining the sheets, Column B, below the “Portal” last row, to enter and fill down name “Tally”. The Line number to be filled down from Portal last number to the end as shown in the expected Result sheet.
Finally, I need to color all the values where the column B contains Portal from column A to M. Green color. Format the cells to Bold.
In future, your comments (explanation) on each line, will be very helpful to combine 10 or more sheets by editing the code.
Combine each Data as sheet name.xlsm
