Simple VBA with explainations
wilsonk
SampleMasterList.xlsm
Sheet1
| Date | Particulars | Bill No. | Quantity | Cash Sale | Credit Sale | Cash Expenses | Expenses Through Cheque |
| 1-Jan-14 | Sales | 447 | 2000 |
| 1-Jan-14 | Sales | 447 | 2000 | | 185500.00 |
| 1-Jan-14 | Salaries | | | | | 68000.00 |
| 1-Jan-14 | Salaries | | | | | 15000.00 |
| 2-Jan-14 | Purchases | | | | | | 254850.00 |
| 3-Jan-14 | Sales | | 300 | 88600.00 |
| 3-Jan-14 | Sales | 448 | 288 | 25950.00 |
| 3-Jan-14 | Sales | 449 | 100 | 68900.00 |
| 3-Jan-14 | Sales | 450 | 400 | 45000.00 | 6000.00 |
| 3-Jan-14 | Sales | UB | 100 | 105000.00 |
| 4-Jan-14 | Sales | 451 | 23 | | 52000.00 |
| 6-Jan-14 | Sales | 452 | 25 | 18850.00 |
| 6-Jan-14 | Sales | 453 | 400 | 78780.00 | 5000.00 |
| 6-Jan-14 | Sales | UB | 100 | 21220.00 |
| 6-Jan-14 | Postage.Telegram | | | | | 850.00 |
| 7-Jan-14 | Sales | UB | 50 | 127000.00 |
| 7-Jan-14 | Purchases | | | | | | 296500.00 |
| 7-Jan-14 | Sales | UB | | 15950.00 | 4000.00 |
| 7-Jan-14 | Staff.Welfare.Expenses | | | | | 1500.00 |
| 9-Jan-14 | Sales | 454 | 2000 |
| 9-Jan-14 | Sales | 449 | 100 | 68900.00 |
