amjadinsaudia
New Member
- Joined
- Jan 2, 2023
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Dear All,
I have an excel file which contains students sheet with month name and school fee challans sheet.
A)
When I click on the roll no. then print of challans on other sheet should be sent to printer with this student record:
1) Roll no. here as challan no there
2) student name and father
3) T.fee and any other arrear
4) contact no.
5) sheet name here as month name there
B)
Challan No._____
Amount._______
After receipt of challans from bank, would like to post it by entering in two fields in students record sheet the challan no. and amount. and same should be updated in paid amount column here in front of that student.
C)
These sheets / workbooks should be copied for another month to use as new month data entry.
Any assistance will be greatly aid the value to the situation.
I have an excel file which contains students sheet with month name and school fee challans sheet.
A)
When I click on the roll no. then print of challans on other sheet should be sent to printer with this student record:
1) Roll no. here as challan no there
2) student name and father
3) T.fee and any other arrear
4) contact no.
5) sheet name here as month name there
B)
Challan No._____
Amount._______
After receipt of challans from bank, would like to post it by entering in two fields in students record sheet the challan no. and amount. and same should be updated in paid amount column here in front of that student.
C)
These sheets / workbooks should be copied for another month to use as new month data entry.
Any assistance will be greatly aid the value to the situation.
