Combine data from multiple sheets with sheet name

[RAJESH1960]

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

 

[RAJESH1960]

If a code is written this way, except portal search data in all sheets and post them to portal sheet one below the other under the available headings. If there are headings in the other sheets which are not in Portal sheet then it should avoid those and remaining matched headings to be posted. You can give the sheet names as A, B, C, ,D E, F and so on and try to write the code. If sheet A is blank, then go to sheet B and so on. Just a thought.?

 

[johnnyL]

Your link does not contain 'Edited Portal' that you mention in post #1.

 

[RAJESH1960]

You have to run the code to get the edited Portal sheet.

 

[johnnyL]

Got it.

 

[RAJESH1960]

Got it.

?. Best of luck..?

 

[johnnyL]

Please note, Not all headings are available in sheets Journal, IGST and CGST. But whatever is available, to be posted.

Do each of these columns have to be matched up individually? In other words, would there be columns not included in the middle or just columns on the end that are not always included?

 

[RAJESH1960]

To match I have already inserted a column in the beginning named Remarks. The problem at hand is getting all the data in the columns from different sheets under the same headings as in Edited portal sheet

 

[RAJESH1960]

This is a kind of reconciliation of Portal and Tally. The next query will be the final one but also the toughest one for me to put it in words.

 

[johnnyL]

I noticed you lost the cell borders in the colored range of cells. Did you want the borders reinstalled?