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>[TABLE="width: 0"]
<tbody>[TR]
[TD="align: right"]3/1/19[/TD]
[TD]cash[/TD]
[TD="align: right"]5200[/TD]
[/TR]
[TR]
[TD]3/1/19[/TD]
[TD]bansal 27[/TD]
[TD="align: right"]1700[/TD]
[/TR]
[TR]
[TD]3/1/19[/TD]
[TD]goyal 45[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]3/1/19[/TD]
[TD]nanu45[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]4/1/19[/TD]
[TD]mahinder[/TD]
[TD="align: right"]3000[/TD]
[/TR]
[TR]
[TD]4/1/19[/TD]
[TD]vishal mohali ph1[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD]5/1/19[/TD]
[TD]hemraj ph1[/TD]
[TD="align: right"]3500[/TD]
[/TR]
[TR]
[TD]7/1/19[/TD]
[TD]satpal ph1[/TD]
[TD="align: right"]15000[/TD]
[/TR]
[TR]
[TD]8/1/19[/TD]
[TD]max 52[/TD]
[TD="align: right"]6700[/TD]
[/TR]
</tbody>[/TABLE]

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