I have a spreadsheet that has a number of columns with information about class rosters, payments and students.
I need a macro that will take that spreadsheet and create payment rosters for each of the classes with the class name, date, total owed to the instructor and a detail of the class . The application can run on Google docs or excel--I'd like to discuss the options. The data is manually pulled from a third party event registration tool, the total tuition summed and the instructors portion (a simple %) calculated. The output is a document or email (again open to discussion) that contains the class date, name of the class, class instructor, total revenue, total due instructor, some boiler plate on terms, and a listing of the the student names the amount each paid.
In discussin with one developer it is clear that I did not make it clear that the sheet has data from mutliple events. I have uploaded a new sheet with data from mulitple events. Each event needs its own statement.
added a better template
After talking to two very helpful people, its become clear this really must be a google app that creates the statement from a google spreadsheet. I know the examples I have provided are excel, but that is because it is what we have to use now. The input is the CSV file named report-11072013-1041.csv and I would like the output to look as close to the Statement template.xlsx as the limited formatting in Google allows.
thank all of you for your input and comments!
8 freelancers are bidding on average $302 for this job
Hello...Would you can just click on discuss button and start chat with me..Would you like,Discuss project with [url removed, login to view] can negotiate about price,time and work. ... Let me do it......I am software engineer....Thank you..