Find Jobs
Hire Freelancers

Excel VBA Script Creation

$10-30 USD

Completato
Pubblicato circa 2 mesi fa

$10-30 USD

Pagato al completamento
I need an experienced VBA script professional who can provide an on-demand solution for my Excel spreadsheets. Excel VBA to be able to run on a file at will. See attached spreadsheet worksheet Start is a sample of the beginning file (there might be more columns than sample file), worksheet END shows a sample of what the final spreadsheet will look like. Sheet1 to End of File Insert 3 columns: I, J, and K I1 title = “Style” J1 title = “Is it Primary Variant” K1 title = “Variant ID” I2 – to EOF, should equal first 4 characters of data in column H Sort by column I J2 to EOF should be When characters in column I changes to new Style enter Yes in column J and enter column A in column K Until column I changes enter No in column J and enter data from column A in column K Repeat to the end of the file. Timelines: - The project needs to be completed urgently, ASAP. To be successful in this role, you should have proven experience in creating VBA scripts for Excel, knowledge of advanced Excel functions, and an ability to deliver high-quality work under time pressure. Ensuring the accuracy of the output is crucial for this project.
Rif. progetto: 37813557

Info sul progetto

43 proposte
Progetto a distanza
Attivo 2 mesi fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
Hey There. An Excel VBA Developer & savant here. Here's a devised course of action. (Correct me if I'm wrong) Inserts three columns (I, J, K) in each sheet from "Sheet1" to the end of the file. In column I, the title should be "Style." In column J, the title should be "Is it Primary Variant." In column K, the title should be "Variant ID." For each row from the second row to the end of the file: Column I should contain the first 4 characters of the data in column H. Sort the data based on column I. In column J: If the value in column I changes, enter "Yes." Until the value in column I changes, enter "No." In column K: If the value in column I changes, enter the data from column A. Until the value in column I changes, enter the data from column A. In summary, the script organizes and categorizes data in columns I, J, and K based on the specified conditions. I get that time is of the essence here. Let's Get in touch. Regards Muhammad Ismail
$25 USD in 1 giorno
5,0 (12 valutazioni)
5,1
5,1
43 freelance hanno fatto un'offerta media di $24 USD
Avatar dell'utente
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$80 USD in 2 giorni
4,9 (555 valutazioni)
8,4
8,4
Avatar dell'utente
Hello, I am an Excel/VBA expert and I would like to help you with your script. Please check my profile and contact me to discuss further details. Regards.
$30 USD in 1 giorno
5,0 (504 valutazioni)
8,0
8,0
Avatar dell'utente
Hi, this is definitely possible, i reviewed the file and i can do this for you immediately. I am available right now. If you are interested, feel free to message me. Thanks, Milan
$20 USD in 1 giorno
5,0 (799 valutazioni)
7,6
7,6
Avatar dell'utente
Hello, I would like to work on your project. I have extensive experience using Excel macros / VBA, data formatting, and data manipulation in Excel. I have had many similar works. Please initiate a chat, share your file, and discuss further details, regarding to the macro functionality, I suggest to have two command buttons, one for selecting the Input file and the other to launch the macro, the resulted file can be saved in the same folder as the Input file and left it open or closed. Best Regards. Zoltan
$25 USD in 1 giorno
5,0 (189 valutazioni)
7,0
7,0
Avatar dell'utente
As an experienced data consultant with a comprehensive knowledge of Advanced Excel functions, database creation, and automation, I am confident in my ability to deliver compelling solutions for your project. On top of my expertise in Excel and Visual Basic functions, I possess exceptional analytical thinking and problem-solving skills which will allow me to tailor-make your desired VBA script within the shortest time possible.
$20 USD in 1 giorno
5,0 (55 valutazioni)
6,2
6,2
Avatar dell'utente
Hello, I am proficient with Excel and VBA and have a lot of experience with making all sorts of macros. I would love to help you with this project, doesn't sound very complicated and I think I could have fun working on it. I am available to start immediately, and I am sure I can do it as you described. Please contact me for more details Thank you, Ivan
$20 USD in 1 giorno
4,9 (147 valutazioni)
5,9
5,9
Avatar dell'utente
Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra
$30 USD in 1 giorno
4,8 (145 valutazioni)
6,2
6,2
Avatar dell'utente
Dear client, I am an experienced Excel VBA professional with a proven track record in creating efficient scripts. I can swiftly deliver a solution to meet your urgent needs. My expertise includes advanced Excel functions, and I am committed to ensuring accurate and high-quality results within your specified timeline. Thanks
$30 USD in 1 giorno
5,0 (19 valutazioni)
5,4
5,4
Avatar dell'utente
Being an IT Project Manager and developer for over two decades, I have a wealth of experience in software development and, particularly, with Microsoft technologies. I specialize in Excel and Visual Basic and have created numerous VBA scripts like the one you need for your spreadsheet. My proficiency extends to advanced Excel functions which will be handy in delivering high-quality work on time. Accuracy is a vital aspect for this project, something I value above all else in my work. My understanding of VBA's capabilities ensures that tasks like sorting data based on specific columns then populating others with pertinent information are carried out flawlessly. Having dealt with various Excel-based projects, I appreciate the sense of urgency required and the need to complete the task ASAP without compromising quality. Moreover, my broader skills as an IT Project Manager give me an edge in not only quickly understanding your requirements but also planning and executing the task effectively. I am confident that given this chance, I will provide you not only with an on-demand solution for your Excel spreadsheet but one that aligns closely with your envisioned final product.
$33 USD in 7 giorni
4,9 (37 valutazioni)
5,4
5,4
Avatar dell'utente
With each job I take on, my main objectives are accuracy, meeting time commitments and ensuring your complete satisfaction. While my freelance profile covers a wide area of expertise including WordPress development, web design, writing and photography, my true passion lies within mastering advanced functions of Excel. Over the years, I have developed complex VBA scripts for numerous projects with similar requirements to yours and delivered high-quality work under strict timelines. My experience in Web Scraping would further add value to the project and since I’am proficient with MS Office tasks and data entry, I can assure you that not a single detail will be missed while implementing the script. Understanding the importance of precision in your work, I commit to delivering an output exactly as per your requirements - three new columns (I, J, K) in Sheet1 with specific formulas filling those columns based on changing values in columns H & I. Moreover, I am always available for collaboration or discussion and can start immediately on this project. You need a freelancer who knows when he needs to go deep into his toolbox of expertise and when he must prioritize delivery without compromising quality. With me, you get both! Thank you and looking forward to working with you on this exciting project!
$30 USD in 7 giorni
4,8 (11 valutazioni)
5,5
5,5
Avatar dell'utente
Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$30 USD in 4 giorni
5,0 (33 valutazioni)
5,2
5,2
Avatar dell'utente
Hi there, My expertise is in Excel/Google Sheets, and I can provide solutions to most Excel/Google Sheets problems, including VBA programming. Working with me will give you good value for your money, as I have a flexible approach to completing your work and am great with deadlines. I will keep you updated throughout the process, and the quality of my work is always high. Please feel free to ping me in the chat box for further discussion. Thank You
$20 USD in 1 giorno
5,0 (40 valutazioni)
4,8
4,8
Avatar dell'utente
Dear Project Manager, Happy to support. Can revert back in ONE HOUR with working code. If interested in availing my support, feel free to reach out and discuss. Regards, MM
$17,50 USD in 1 giorno
5,0 (3 valutazioni)
4,2
4,2
Avatar dell'utente
Hello, I am a skilled Excel/VBA developer and I'd love to have the opportunity to work on your project. I've taken a look at your project carefully and I cando this job. Please get int ouch, so we can discuss this further. Regards,
$25 USD in 1 giorno
5,0 (3 valutazioni)
3,8
3,8
Avatar dell'utente
As an Excel expert with a strong grasp of VBA and macros, I can provide the on-demand solution you need for your spreadsheets. My 10 years of experience in Excel automation have given me vast exposure to many complex projects that required combining multiple functions like the one you're issuing. In fact, I specifically remember a project where I had to implement similar functionalities to your requirement; inserting columns, sorting data by a specific column and which would consequently trigger responses on other columns. I also understand that time is of utmost sensitivity for you. Here, too, my record is impeccable. Being a results-driven professional, I am no stranger to working swiftly while maintaining excellent quality standards. Moreover, I highly regard the accuracy of outputs—something that aligns well with the requirements of this project.
$40 USD in 2 giorni
5,0 (8 valutazioni)
3,1
3,1
Avatar dell'utente
I am writing to express my interest in the Excel VBA script project you have posted, which requires an experienced professional to provide on-demand solutions for Excel spreadsheets. With my extensive background in VBA scripting and advanced Excel functions, I am confident in my ability to deliver the high-quality solution you are seeking within the urgent timeline specified.
$20 USD in 3 giorni
5,0 (2 valutazioni)
3,0
3,0
Avatar dell'utente
Good Day, I trust this message finds you well. I am excited about the opportunity to contribute to your project by creating an Excel VBA script. With a solid background in Finance, having graduated from Commerce College, and boasting over 15 years of experience in educational and analytical roles, I am confident in my ability to deliver professional and accurate results. My expertise includes advanced skills in Excel functions, web scraping, web search, Power BI, data mining, Access, and DBMS. I have successfully utilized Microsoft Excel to report and analyze student data in a controlled system, showcasing my proficiency in the field. I am committed to providing a solution that meets your requirements and am available to address any questions or concerns you may have. With my dedication to quality and efficiency, I am confident in my ability to deliver timely and precise results for this task. Thank you for considering my proposal. I am eager to contribute to the success of your project. Best regards, Christine Zekrian
$17 USD in 2 giorni
5,0 (3 valutazioni)
2,3
2,3
Avatar dell'utente
Hello, I am an experienced VBA script professional ready to provide an on-demand solution for your Excel spreadsheets. With expertise in creating VBA scripts for Excel and a deep understanding of advanced Excel functions, I am well-equipped to fulfill your requirements efficiently and accurately. I will insert the necessary columns, title them accordingly, and execute the specified sorting and data entry tasks as outlined in your project description. Committed to delivering high-quality work under time pressure, I will ensure that the project is completed urgently and meets your expectations. Thank you for considering my proposal, and I look forward to assisting you with this task. Sincerely, Muzafar
$10 USD in 1 giorno
5,0 (2 valutazioni)
2,2
2,2
Avatar dell'utente
Hi there, I'm excited to reach out to you! Your project sounds captivating, and I'm enthusiastic about using my skills to contribute to its success. Let's kick things off by chatting about the details and initiating our collaboration. Thank you!
$20 USD in 1 giorno
4,1 (7 valutazioni)
2,3
2,3
Avatar dell'utente
Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, C#, and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.
$20 USD in 7 giorni
5,0 (2 valutazioni)
1,5
1,5

Info sul cliente

Bandiera: UNITED STATES
Nashville, United States
5,0
20
Metodo di pagamento verificato
Membro dal dic 12, 2011

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.