Find Jobs
Hire Freelancers

Excel - Convert selected cells to a value in another column using conditions in VBA.

$10-30 USD

Terminado
Publicado hace más de 9 años

$10-30 USD

Pagado a la entrega
**See attached workbook** Use the ranges at the bottom of the sheet to determine if the percentages above should be a 1,2,3,4, or 5 based off the the 1,2,3,4, and 5 listed in the bottom left hand corner (in green). If the number has a .49, then the number rounds down before conversion. If the number has a .50, then the number rounds up before conversion. This must be EXACT. (Example: 81.49, 81.02, 81.30 would all round down to 81. If this was under the NC column, it would then be converted to a 2. Example: 83.50, 83.76, 83.68 would all round up to 84. If this was under the NC column, it would then be converted to a 3. Please do not put anything in the columns called blank. There is no rating of "3" currently for the HC columns ONLY. The output goes into the column to the right that is currently labeled "Number". Also, the rounding may need to be changed in the future so this should be easily editable such as anything from a .75 would round up, and <=.74 would round down. Please leave column A blank currently.
ID del proyecto: 6294224

Información sobre el proyecto

22 propuestas
Proyecto remoto
Activo hace 10 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hey There, Thanks for posting the project. Its looks feasible and am Interested to do it. Next steps: Lets discuss/validate the complete requirement and I can start to get this done with required quality output. I am an excel/access VBA automation professional having 7+ years of experience and can do it with the required quality. Lets discuss more online on chat. Thanks, Abhinav
$34 USD en 0 día
4,9 (164 comentarios)
6,4
6,4
22 freelancers están ofertando un promedio de $26 USD por este trabajo
Avatar del usuario
A proposal has not yet been provided
$50 USD en 1 día
5,0 (205 comentarios)
7,4
7,4
Avatar del usuario
Hi, I'll be happy to write this macro for you, ans can do it now if you're ready to award Please feel free to message me if you need to discuss any questions
$40 USD en 0 día
4,9 (254 comentarios)
7,6
7,6
Avatar del usuario
Hello. I've done it with excel formulas only. I can share the file with you if you're interested. Wait for you response. Best regards
$20 USD en 1 día
5,0 (139 comentarios)
6,8
6,8
Avatar del usuario
Hi there. Its a pretty simple job to do via VBA macro. I will get this done in less than an hour. Lets proceed and get over with it. Usman.
$30 USD en 1 día
5,0 (72 comentarios)
6,8
6,8
Avatar del usuario
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD en 2 días
4,9 (115 comentarios)
6,2
6,2
Avatar del usuario
Hi, I am an excel and vba expert. I can do this project in 5 minutes,contact me please. Kind regards, Dragos!
$10 USD en 0 día
5,0 (85 comentarios)
5,8
5,8
Avatar del usuario
I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files and hosting command buttons and other controls (e.g. rounding limit) if necessary. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. Regards
$25 USD en 1 día
4,9 (63 comentarios)
5,7
5,7
Avatar del usuario
Hello ready to start asap to deliver you,it seems clear and I am thinking it can be done using conditions,.. but you may need it in the form of macro, please send me message to discuss more, I can deliver it to you fast, also about me: I am m.s of systems engineering and b.s of industrial engineering, and excel(dashboard, pivot tables, charts, conditions, conditional formatting, statistical, financial, mathematical, string, time, date,..functions) and vba expert. I have done similar projects and I am confident about my profession, I also accept revisions and removing errors and minor changes in future for free, whenever you are ready lets go. I have good command of English that I think can be useful for this project.
$20 USD en 1 día
4,9 (60 comentarios)
5,2
5,2
Avatar del usuario
Hello, I am ready with the result. I am unable to attach the spreadsheet anywhere. Please PM me so that I ca send you the result for your review. Thank you.
$20 USD en 1 día
4,9 (46 comentarios)
4,6
4,6
Avatar del usuario
Done it, complete with editable "rounding". Happy to send you "limited" version to test it right now if you send me a Private Message. You can have the full version as soon as you pay the fee into the site. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Hope you find this of interest and look forward to hearing from you. Bob Allen-Turl
$30 USD en 1 día
4,6 (11 comentarios)
4,5
4,5
Avatar del usuario
Hi, I am very confident that I can do this for you at a cheap rate. I have done a lot of projects that requires advanced vba coding to suit my client's needs. I am very good in math and logic and is very sytematic in working. I will be presenting this in the most cleanest and most user friendly version for you. I will be doing this tonight for you to check on. As a sampler, I would be doing vba code and my work will be very dependent on the inputs that you will be providing. Please message me so we can discuss and I could suggest more on what to do on your file before I start to work on this tonight. Thanks and hope to hear from you soon.
$15 USD en 1 día
5,0 (12 comentarios)
2,8
2,8
Avatar del usuario
Hi, I have 6.5 years expereince in VB, VBA, Excel macros and VBS. I am avaialble to start right now, and the estimated delivery time is around 3 hours. Please revert back for questions, If any. Regards, Param
$30 USD en 1 día
5,0 (1 comentario)
1,4
1,4
Avatar del usuario
Hello Dear Sir, I fully understood your job description. I'm really interested and ready to work as soon as possible. I hope you consider me as part of your staff. I'm a fast-learner, speed typist, flexible and dedicated. I am looking forward to your good response. More about Me: I am a Mechanical Engineer by Profession. I have just completed my graduation from MIT Pune University. I am well versed with all the MS Office tools. I Have a typing seed of 60WPM. I am dedicated towards my work. Providing a quality output towards end is my ultimate aim. I am a new bird in this sky of freelancing but i have come up with strong wings of dedication and smart work to fly high and stay long in this sky. I use internet on my laptop 8 hours a day. Do Consider. Thank You.
$10 USD en 1 día
5,0 (2 comentarios)
1,2
1,2
Avatar del usuario
Hello. I can get this done without VBA, and it be automatic as soon as a value goes into the B column. I'm doing this using formulas only (using an IF statement combined with ROUND, ROUNDUP, and ROUNDDOWN statements). I'm also using a field where you can put in the rounding up number (It's currently set to 0.5, so anything above or equal to 0.5 will be rounded up, and anything else will be rounded down, but this number can be altered, and the whole spreadsheet will automatically use the new rounding number. I can also edit this to use a separate number for each sub-heading if you'd prefer). I've already got the formulas 50% completed, but if you can give me a couple of days, I can get this spreadsheet done to 100% completion for you. A little about me : I've got an IT background, and I've been working with excel for the past 10 years. I know VBA, but this spreadsheet doesn't seem to need it, as it can easily be done with formulas, and it will automatically be up to date. If you prefer VBA, I can switch it up to use a button. Let me know if you're interested in me working on this project, and I'll get it done within 2 days of you accepting my offer.
$30 USD en 2 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
You explained very well what I have to do. I can do it with basic formulas and I can keep sheet organized.
$35 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I'm working on your project, I finish it in 2 hours. I am a new freelancer with over 3 years experience in Excel. Let me show you my work
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi, I had actually prepared the spreadsheet for you. It's available anytime you'll need it. I did not use VBA scripts to keep the file simple, anyway it can be easily done with excel formulas and some conditions. :) You can give me your email and I can send the file to you now right now. I'm doing this because I'm a new freelancer and will need to build my reputation first. So the fee is also at the minimum of $15.00, but if in case you didn't like my work, you have no any obligation to pay me. Should you have queries or problems with my work, you can always send me a message. Hope you can trust me on this project. Thank you.
$13 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I've done the excel file so I can send you the file immediately after you give the project to me. I also add function so that you can change the range right from the green cells. Cheers, Ferdi
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
A proposal has not yet been provided
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
NA, United States
4,5
25
Forma de pago verificada
Miembro desde mar 2, 2014

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.