Create an Excel workbook with Macros

Probíhá Zveřejněno před 5 lety K zaplacení v momentě doručení
Probíhá K zaplacení v momentě doručení

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.

Zadávání dat Zpracování dat Excel Visual Basic Visual Basic pro aplikace

Identifikační číslo projektu: #17851561

O projektu

7 nabídek Projekt na dálku Aktivní před 5 lety

Uděleno uživateli:

$30 AUD za 1 den
(0 recenzí)
0.0

7 Freelnceři na tento projekt zveřejňují nabídky v průměru $36

schoudhary1553

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 Další

$100 AUD za 2 dní
(292 Recenzí)
7.7
asmamukhtaruolcc

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 Další

$30 AUD za 1 den
(9 Recenzí)
3.4
an1566706

I read your project description……..Create an Excel workbook with Macros .......and we are very exited to work on it We are an group and we have an expert & qualified to accomplish your project in professional & Další

$25 AUD za 1 den
(0 Recenzí)
0.0
visionsoft60

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 Další

$28 AUD za 7 dní
(0 Recenzí)
0.0
ZeyadAlian

it's quite easy and solvable , i will deliver that excel sheet as soon as possible and as clear as possible

$20 AUD za 1 den
(0 Recenzí)
0.0