Simple VBA with explainations
wilsonk
SampleData.xlsxSheet1
| Date | Particulars | Bill No. | Quantity | Cash Sale | Credit Sale | Cash Expenses | Expenses Through Cheque |
| 3-Jan-14 | Sales | 300 | 88600.00 | ||||
| 3-Jan-14 | Sales | 448 | 288 | 25950.00 | $500 | ||
| 3-Jan-14 | Sales | 449 | 100 | 68900.00 | |||
| 6-Jan-14 | Sales | 452 | 25 | 18850.00 | $6,000 | ||
| 6-Jan-14 | Sales | 453 | 400 | 78780.00 | 5000.00 | ||
| 9-Jan-14 | Sales | 454 | 2000 | $3,000 | |||
| 9-Jan-14 | Sales | 449 | 100 | 68900.00 | |||
