Sedang Disiapkan

Create an Excel workbook with Macros

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.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel workbook software, create excel database can posted forums, convert excel workbook windows application, excel vba create new workbook with one sheet, excel vba create new workbook and copy sheets, excel macro to create new workbook based on value in cells, excel macro create new workbook with name, excel vba create new workbook and name it, excel vba create new workbook and copy data, excel vba create new workbook and save, excel vba create new workbook from template, create excel file visual, excel formatting macros, convert excel workbook, excel macros variables given target totals, create excel mysql sample, create excel workbook datatable using aspose, create front end search entire excel workbook, create search form excel workbook, create excel web application macros

Tentang Majikan:
( 0 ulasan ) Hawthorn, Australia

ID Projek: #17851561

Dianugerahkan kepada:

$30 AUD dalam sehari
(0 Ulasan)

7 pekerja bebas membida secara purata $36 untuk pekerjaan ini


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 Lagi

$100 AUD dalam 2 hari
(292 Ulasan)

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 Lagi

$30 AUD dalam sehari
(9 Ulasan)

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 & Lagi

$25 AUD dalam sehari
(0 Ulasan)

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 Lagi

$28 AUD dalam 7 hari
(0 Ulasan)

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

$20 AUD dalam sehari
(0 Ulasan)
$20 AUD dalam 3 hari
(0 Ulasan)