I need an Excel Macro Enabled Workbook expert to fix and improve my dropdownlist table, using Visual Basic editor if necessary

[login to view URL] the "trainings" column I have added a code in Visual Basic, this code allows to select multiple from the list. Can you modify that code using this video tutorial, so that I can also remove selected options by clicking on them again on the dropdown list.

[login to view URL]

Also when you select option "No training" I would not want this to add itself to the list, but to substitute all the already selected options. For example if the user has selected "Fire Warden", when he selects "No training", instead of the cell showing "Fire Warden, No training" - it should just show "No training"

2. For the "cost" column, can you make it so that the display cost is the sum of the costs of the selected column

3. Can you hide the #N/A or make them appear as blank "" where there has not been an option selected in the related field (for example for office capacity, hide the #N/A where there has no been an office selected in the office column

4. Can you fix the #N/As that appear in the cells where there has been an option selected (for example for the office capacity (F7) where Brighton has been selected as office location)

5. For office capacity column, each time someone books that office location (selects it on the office location column, can we display something like: 99/100) So for example if someone introduces a new row where they select London as an office Location, can we change displayed capacity of London Office to 499/500

6. For Time Column I have created a list with 3 options to choose; "1 day, 1 week, 1 month" and the equivalent of hours to this in the Office Information Sheet. Please I would want that when a user selects either of these 3 options, the equivalent in hours displays in the cell. Also I want to give the option for users to input the hours manually in HH:MM format.

Please I would need a brief description to how each of the 6 points are done so that I know what I am able to answer any questions to my peers. I will still hire you for more work, I am looking for a regular and will give you a lot of orders.

Taidot: Excel, Visual Basic, JavaScript, PHP, Tietojenkäsittely

Näytä lisää: need excel macro input data, need excel macro, i need a macro programmer, i need excel data entry, i need excel expert, i need to hire an seo expert, google downplay i need a flash enabled browser to watch my dog granddaughters basketball game, i need a dry ice qualified expert worked oil and gas engines stations, i need a macro wirtten and need a freelancer, i need an microsoft outlook 2016 expert, i need excel freelancer, i need excel help, i need excel help in agra, i need to hire a photoshop expert, i need to hire a seo expert, I need excel work, excel macro enabled template, excel macro enabled template vs workbook, macro enabled workbook

Tietoa työnantajasta:
( 0 arvostelua ) London, Spain

Projektin tunnus: #30206555

Myönnetty käyttäjälle:


Hi, I have seen your task and interested to complete it. I assure you that i will do it with 100% accuracy and satisfaction. Just inbox me details, Thanks

£50 GBP 7 päivässä
(0 Arvostelua)

10 freelanceria on tarjonnut keskimäärin £105 tähän työhön


(481 arvostelua)
(170 arvostelua)

* MsEXCEL Business programming and database expert. American English is my first and only language. Question: Will multiple users be using this workbook at the same time? At your earliest convenience, please attach a Lisää

£189 GBP 7 päivässä
(64 arvostelua)
(16 arvostelua)

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Lisää

£50 GBP 2 päivässä
(13 arvostelua)
(20 arvostelua)

I read your dscription and very interested in it as a MACRO developer I will finish them within 7 days with high quality. Thanks

£200 GBP 7 päivässä
(4 arvostelua)

Hello, I would help you to fit it with a minimum price (it's easy but it take some time to finish). I'm working on another project for now -- and will work on this if you can wait for a few hours from now. (You can che Lisää

£60 GBP 1 päivässä
(5 arvostelua)

advanced 50% your project and i will done your project within 6days then i am send your project for your email plz send your email

£135 GBP 7 päivässä
(0 arvostelua)