Append sheets with a code.

[RAJESH1960]

Hello
JohnnyL. I have tested your last app with so many different data of HDFC bank and I have not faced any problem with any of them. It is just perfect.
Today When I started working on a different bank I found it quite different. The data is not in a single sheet but spread in different sheets which can be 1 or 2 or any number depending on the number of transactions. The one I am working on now has 23 sheets of data. I have to append the data of each sheet to one new sheet and then customize it. The headings of sheet 1 starts from row 3 and the headings of the remaining sheets start from row 1. Some of the headings are different which I will be able to change in your code to customize. The sheet name which I receive is Table1,2,3 and so on by default.
So, if you can combine / append the data with a code then the rest of it will be easy. Right now I have manually combined the data and changed the format where ever necessary. I was not able to format some of the numbers in the amount columns which I am sure you can figure it out with your expertise. The cells which I was not able to convert to number are marked in yellow in the SBI sheet.

Customize SBI.xlsm

 

[RAJESH1960]

I just assumed man. If I had said 1 second then too you would have called me a liar.

 

[johnnyL]

You can display messages to the Immediate window instead of a msgbox.

 

[RAJESH1960]

Next time you can teach me more about that. Gtg now. See you soon JohnnyL

 

[johnnyL]

Still ... 1.3 seconds to load 23 sheets and process them, that is pretty kewl!

 

[johnnyL]

Be safe!