RAJESH1960
Banned for repeated rules violations
- Joined
- Mar 26, 2020
- Messages
- 2,313
- Office Version
- 2019
- Platform
- Windows
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
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