Maintaining a ledger book

[raj0007]

Hello everyone I need a Help from all pro to create excel sheet for maintaining a ledger book which picks the data from single sheet cash data entry. like

<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>

3/1/19	cash	5200
3/1/19	bansal 27	1700
3/1/19	goyal 45	2000
3/1/19	nanu45	3000
4/1/19	mahinder	3000
4/1/19	vishal mohali ph1	2000
5/1/19	hemraj ph1	3500
7/1/19	satpal ph1	15000
8/1/19	max 52	6700

<tbody>
</tbody>

all these entries to be sorted in the respective ledger account autofill. along with date. kindly help me out

 

[onlyadrafter]

Re: Need help to create a excel for maintaining a ledger book

Hello,

How many tabs are in your spreadsheet before filtering? If more than one, where is your source data tab located. Is this method OK to continue with?

 

[raj0007]

Re: Need help to create a excel for maintaining a ledger book

sir I have only one tab before filtering and maintaing the payment recieved in that sheet . after your filteration I got the data of indivdual in the sheets . now if I enter the bills in the row after refreshing the filter button it got deleted.

 

[raj0007]

Re: Need help to create a excel for maintaining a ledger book

@onlydayafter sir the code you have given only applicable to limited rows when I add data about 1500 rows its not working can you help me as I not much much pro in the sheet