Find Jobs
Hire Freelancers

Excel VBA script to clear specific cells when contents of other cells change

£10-20 GBP

Terminado
Publicado hace más de 5 años

£10-20 GBP

Pagado a la entrega
Background: Excel spreadsheet has two workbooks: One for data entry, one for controlling entered data. Entry to a range of cells (A1:A10) on data entry sheet is LOV controlled by a table on the control sheet. The table controlling the LOV is exhaustive and the user cannot enter values outside the range. A second range of cells (B1:B10) on data entry sheet are controlled by an LOV, which is dependant on the value selected in the first LOV. Again, the LOV is exhaustive and the user cannot enter values outside the range. All of the above is designed and working as intended - it is for background only. Spec of what is required: Excel VBA script that automatically clears the contents of either cell when the value in its neighbouring cell changes. Typical use case: User picks on A1 LOV and selects "Fruit" as the entered value. When B1 cell is selected the LOV displays "Banana: Apple: Pear" as valid choices. User selects "Pear". User then picks A1 LOV again and changes value to "Vegetable" - the value in B1 is automatically cleared without user input. When B1 cell is selected the LOV displays "Potato: Carrot: Turnip" as valid choices. User selects "Potato". User then picks B1 cell again and clears the entry to NULL. At this point cell A1 contents is automatically cleared without user input. Notes: The cells to be automatically cleared will be specified as a range of rows. It must be possible to tweak the code to match the final design of the spreadsheet, so the range of cells to be cleared must be configurable. Editing the VBA code directly to change the range will be sufficient. Exact version of MS Excel is TBC. Some additional assistance may be needed during the development of the spreadsheet - please indicate your hourly rate for this work separately from the delivery of the initial code.
ID del proyecto: 18204425

Información sobre el proyecto

24 propuestas
Proyecto remoto
Activo hace 5 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, I am a highly experienced developer, with 14+ years of professional experience and excellent English communication skills. I can definitely help you with the required changes to your Excel spreadsheet functionality as depicted in your description. Would be great if you provide a sample of your current excel sheet. My hourly rate is 35 GBP. Feel free to checkout my reviews and project completion rate (100% completion rate). Looking forward to working together for the long term.
£35 GBP en 1 día
5,0 (2 comentarios)
2,5
2,5
24 freelancers están ofertando un promedio de £20 GBP por este trabajo
Avatar del usuario
I have 4 years experience in Excel VBA, VB, Google Spreadsheet, Google Spreadsheet Script, JS and more than 10 years in Excel. Thousands of different tasks has been fulfilled from a simple daily routines with formulas and VBA to the complicated VBA projects in microbiology. I am looking for the projects on: - Excel - Excel VBA - Google SpreadSheet - Outlook VBA - Visual Basic - Data processing - Web scraping Mohsan
£23 GBP en 1 día
5,0 (83 comentarios)
6,3
6,3
Avatar del usuario
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards
£18 GBP en 1 día
4,9 (94 comentarios)
6,1
6,1
Avatar del usuario
Hello, I am Excel and VBA expert. I can do this project (Excel VBA macro) today. (range of cells to be cleared can be configurable in selected sheet or in vba code). (hourly rate is £15) If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
£25 GBP en 1 día
5,0 (95 comentarios)
6,0
6,0
Avatar del usuario
I am proficient with excel macro/VBA development, I can write the macro to perform data clearance as requested, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project. For continuing tasks, I would like to charge £15/hour.
£20 GBP en 1 día
5,0 (81 comentarios)
5,8
5,8
Avatar del usuario
Hi, My name is Virendra. An Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. My hourly rate is $10/hr. Ready to start please reply soon. Thanks, Virendra
£20 GBP en 1 día
4,8 (71 comentarios)
5,5
5,5
Avatar del usuario
1. Expert in Excel, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction
£50 GBP en 1 día
4,8 (63 comentarios)
5,6
5,6
Avatar del usuario
Hello, I am Luis from Venezuela and it will be my pleasure to help you with this project. I can assist you with your Excel requirements. Please contact me by chat and then we could discuss better your project! Kind regards, Luis Romero
£20 GBP en 2 días
5,0 (111 comentarios)
5,4
5,4
Avatar del usuario
Hello sir, I have 4+ years of experience . I got your points. I can work for you. So please share more details about your requirements. So please contact me. Tell me your quote what should you prefer.
£13 GBP en 1 día
5,0 (37 comentarios)
4,9
4,9
Avatar del usuario
Hello, I have worked on over 200+ projects in different freelancing websites over the past 10yrs. I have the ability to learn things quickly and solve problems efficiently. From small excel tasks like lookups, formulas, data extract to bigger tasks like Dashboards, templates, complex calculations, integrations, plugins i have a vast experience in excel vba development. Looking forward to hear from you. Thanks, Simple
£15 GBP en 7 días
5,0 (27 comentarios)
4,1
4,1
Avatar del usuario
Hi Good Day! A serious freelancer here! I can help you to complete this work in 1 days. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete every project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
£18 GBP en 1 día
5,0 (25 comentarios)
3,8
3,8
Avatar del usuario
"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"
£20 GBP en 1 día
4,9 (17 comentarios)
3,9
3,9
Avatar del usuario
Hello there i can do that fast and easy lets discuss about the details and how the file must look like my best regards
£18 GBP en 1 día
4,7 (11 comentarios)
3,2
3,2
Avatar del usuario
hii. am good handed in excel vba . i can do this fucntionality. thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks
£20 GBP en 1 día
5,0 (2 comentarios)
1,0
1,0
Avatar del usuario
Sir I am fresher in this app pe I hve the experience of 3yrs im doing diploma sir i want to can do that
£10 GBP en 30 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
£18 GBP en 1 día
5,0 (2 comentarios)
0,0
0,0
Avatar del usuario
I am confidence
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Pretty simple to do, I’d actually configure the whole column all together. All you’d need to do is to follow the instructions I leave on data page for adding more content.
£15 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Dear Hiring manager, Thank you for posting your job opening for Data Entry. I have five year of data entry experience and I have performed all of the duties listed in your job description. I have a excellent typing speed and data entry skills which make me a good fit for this data entry. I also have experienced in working with Microsoft tools e.g. Excel, Word, Powerpoint. I can assure you that I can perform data entry tasks with high accuracy while maintaining the 100% quality. Please feel free to ask any question you may have Thanks & Regards Shiva Chandra
£18 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
Hi! I have a VBA experience with 4 years experience as Data Developer. Optimized number of processes and automized various Excel files to simplify life and minimize the errors.
£13 GBP en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am good in VBA and MS excel. I am deliver within time Work satisfaction is guaranteed. This is my first project
£11 GBP en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED KINGDOM
Fleet, United Kingdom
5,0
2
Forma de pago verificada
Miembro desde nov 21, 2018

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.