Create an Excel workbook with Macros
$10-30 AUD
Paid on delivery
I would love some assistance with the following problem.
Each year for school camps we take the students preferences 1-6 of who they'd like to bunk in with for the week. We usually sort this out manually, but there has to be a much quicker way to do it using Excel. (Is this a marriage problem?- I just read about it on this site)
+Each student should have at least one preference- preferably their top 3 but not necessarily.
+The problem is that some students aren't chosen by anyone else, but they must still be placed with another student of their choosing.
+There are rooms for 4, 6 and 8 students to a room. (Make it clear in the spreadsheet where this information can be changed based on the quantity of rooms that sleep 4 or 6 o 8)
+Although the image shows 26 possibilities of the preferences as given by students, there are actually 104 students.
+I want to be able to reuse the spreadsheet for the students of the opposite genders.
The following spreadsheet displays a sample.
Project ID: #17851561
About the project
Awarded to:
7 freelancers are bidding on average $36 for this job
Hello! This is Vibrant Webtech and I was glad to see that you're looking for help for project Create an Excel workbook with Macros. I've delivered more than 400 + projects in the last 5 years and this makes me ver More
hi, I have 8 Years Experience in Excel. i am very good in Excel VBA, macro, chart etc. if you want to see my excel skills I can share with you some of my work on excel. I feel fit myself for this project. Please conta More
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have More
it's quite easy and solvable , i will deliver that excel sheet as soon as possible and as clear as possible
