Fast Excel VBA Function Creation

£10-20 GBP

Terminado

Publicado

hace 4 meses

£10-20 GBP

Pagado a la entrega

I urgently require an Excel VBA specialist with expertise in creating custom functions. Due to my urgent timeframe, it's crucial to find a freelancer who can hit the ground running with limited guidance. Ideal Skills and Experiences: * Strong knowledge in Excel VBA * Proficient in creating custom functions * Ability to deliver quickly * Great communication skills Hi All, Hoping someone might be able to help me. I have a spreadsheet (unfortunately can't share) with some tasks in it that need tracking. The first tab has a number of questions with simple Applicable or Not Applicable in a drop down list. The second tab has a number of rows with column I having another drop down list in it. What I am hoping to do is format it so if the answer to the question on the first sheet is Not Applicable (selected by the dropdown box a set number of rows (which I need to be able to set) will have the applicable cell in column I set to "Not Applicable" in text and then hide the rows in the sheet. for example sheet 1 A1 Do you require a car A2 (Answer) Not Applicable (drop down list) Sheet 2 Set text in Cells I 1:10 to "Not Applicable" Hide rows 1:10 If user changes A2 (sheet 1) to Applicable (drop down list) sheet 2 should un hide rows and change the text to "Brag Status not Selected" Hopefully this makes sense. Thanks in advance.

Visual Basic for Apps

ID del proyecto: 37668556

Información sobre el proyecto

9 propuestas

Proyecto remoto

Activo hace 4 meses

¿Buscas ganar dinero?

Dirección de email

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:

@MimiFL

Hi, this is definitely possible. What you need is small VBA (macro), that will run once the cell changes. If you are interested, we need to create a sample sheet, that looks like yours (since you cannot share it). I am available right now. Thanks, Milan

£15 GBP en 1 día

5,0

(798 comentarios)

7,6

9 freelancers están ofertando un promedio de £17 GBP por este trabajo

@zafarfarooq612

Hello, I am an Excel VBA expert and I am writing to express my keen interest in the urgent requirement for an Excel VBA specialist with expertise in creating custom functions. Given the time-sensitive nature of the project, I am confident in my ability to meet your needs efficiently and effectively. With a strong foundation in Excel VBA, proficiency in crafting custom functions, and a track record of delivering high-quality results promptly, I am well-equipped to tackle the tasks outlined in your project. My commitment to clear communication ensures that I can hit the ground running with limited guidance. I am excited about the opportunity to contribute to your project's success and would welcome the chance to discuss further details. Best regards, Zafar

£20 GBP en 1 día

4,9

(52 comentarios)

5,0

@mobimubasir

Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.

£15 GBP en 1 día

4,9

(20 comentarios)

4,2

@farahgul2004

Dear Farah, I came across your project and I think my skills could help you tackle this in record time. With over six years of experience in Data Entry, Data Processing, and specific proficiency in Excel VBA, your task aligns perfectly with my expertise. Your requirement of creating custom functions and delivering quickly is something I'm quite comfortable with; it's like second nature to me. To exemplify a possible solution, let's consider the scenario you've described. Utilizing an "If" statement within my created VBA function will ensure that if 'Not Applicable' is selected on the first sheet, rows 1:10 on the second sheet will be hidden, and cells I1:I10 will have the corresponding text set as "Not Applicable". Similarly, if the answer changes to 'Applicable', the necessary changes on Sheet 2 will be triggered without any hassle. My solid communication skills and transparency make me a great fit for your urgent project. I'll send regular updates about the progress made and involve you in every decision-making process. Choose me for not only swift delivery but exceptional solutions created with minimal issues because it's my strong suit to hit the ground running with limited guidance. Thank you for considering me for your important project - let's bring your vision to life together! Best regards, Farah G

£15 GBP en 1 día

5,0

(1 comentario)

2,3

@ianalyticain

Hi, I can create VBA function for you as per the steps you have mentioned and can provide complete work by EOD today. Please let me know if you are interested Thanks

£35 GBP en 1 día

5,0

(1 comentario)

1,1

@suhas1890

Hi, there! My name is Suhas, and I believe I'm the Excel VBA expert you're looking for! Unlike other freelancers, my 3-year experience demonstrates my penchant for accuracy and attention to detail- qualities that are quintessential for quickly but effectively developing VBA functions in your time-constrained endeavor. I've successfully tackled over a hundred similar tasks, showcasing my agility in working on different projects with varying demands. When it comes to your project's specifics, I understand the importance of swift execution. In your case of formatting cells according to dropdown responses and hiding selected rows, my proficiency in Excel VBA allows me to accomplish this precisely while ensuring readability and ease for future reference. Moreover, as an experienced professional, I've learned to anticipate potential roadblocks and have the skills to proactively navigate them. Consequently, you can expect not just a speedy turnaround but also a reliable solution. Lastly, communication is fundamental in any collaboration. My 4.4 out of 5 rating attests to my ability to actively involve clients throughout the process while providing timely updates. Clear understanding of requirements will only facilitate the accurate execution you need in this time-sensitive project. Thank you for considering me!

£10 GBP en 7 días