Nikhil Patki
New member
Dear Admin,
I work in proprietary firm providing school bus service to students of various schools
Unfortunately I'm the only person in my firm using System and Ms-Office.
Even my Boss isn't tech savvy. He uses only basic features like sending, checking mails, and inputting data in my absence.
Being school bus service provider
I've to maintain data in excel sheets ( workbooks ) as follows
1. Pickup / Drop points
2. Vehicle master
3/ Students Master maintaining their pickup / drop points in detail having route name, km slab, annual fees, discount, final fee amount,
also various instalment headers, adding their payment details as and when they pay.
calculating total amount received per instalment, calculating balance amount against each instalment
4. route wise sheet separately for primary and pre-primary.
i want to automate the process.
But being recently have starting learning about advance excel and vba / macros
i face plenty difficulties.
Also recently my boss wants salary slips to be generated for each employee every month.
I need proper guidance so as I can be able to create a automated system for all the routine tasks
as such that i won't have to manually keep updating multiple sheets everytime when their is addition or deletion in data
Even as the data changes each academic year I want to create a template where i can change few things
and ensure hassle free data maintenance each year.
also there should be specific data to be input whereas other columns will be automated and can't be changed / edited
I work in proprietary firm providing school bus service to students of various schools
Unfortunately I'm the only person in my firm using System and Ms-Office.
Even my Boss isn't tech savvy. He uses only basic features like sending, checking mails, and inputting data in my absence.
Being school bus service provider
I've to maintain data in excel sheets ( workbooks ) as follows
1. Pickup / Drop points
2. Vehicle master
3/ Students Master maintaining their pickup / drop points in detail having route name, km slab, annual fees, discount, final fee amount,
also various instalment headers, adding their payment details as and when they pay.
calculating total amount received per instalment, calculating balance amount against each instalment
4. route wise sheet separately for primary and pre-primary.
i want to automate the process.
But being recently have starting learning about advance excel and vba / macros
i face plenty difficulties.
Also recently my boss wants salary slips to be generated for each employee every month.
I need proper guidance so as I can be able to create a automated system for all the routine tasks
as such that i won't have to manually keep updating multiple sheets everytime when their is addition or deletion in data
Even as the data changes each academic year I want to create a template where i can change few things
and ensure hassle free data maintenance each year.
also there should be specific data to be input whereas other columns will be automated and can't be changed / edited
