Find Jobs
Hire Freelancers

I need some VBA coding for Excel

$30-250 USD

En cours
Publié il y a environ 7 ans

$30-250 USD

Payé lors de la livraison
I need some VBA coding for Excel Here’s the context: On Worksheet 1 in the spreadsheet, I will be pasting several columns worth of data (which I will be pasted over day after day as new data comes in). Column B will always contain a list of order numbers. (I am reserving column A for the macro command button) On worksheet 2, Column A of the same spreadsheet, I will be pasting a list of order numbers. I need a button on worksheet 1 that triggers a VBA macro. That macro should - Delete all order numbers on worksheet 1, column 1 that are NOT found on worksheet 2, column 1. Also delete their associated rows and columns. The result should be that there is no trace of any order on worksheet 1, column 1 if it is not also on worksheet 2, column 1 - Of the orders than are left on worksheet 1, column 1, delete all duplicate order numbers WITHOUT deleting the rows (because there is other data in the columns that I want to retain. I have attached a .jpg to show you what I mean.
N° de projet : 13580310

Concernant le projet

7 propositions
Projet à distance
Actif à il y a 7 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
7 freelances proposent en moyenne $80 USD pour ce travail
Avatar de l'utilisateur
I can do exactly what you need within 24 hours or even sooner if it's critical. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to complete your project. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com.au/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com.au/projects/Excel/Recreate-online-calculator-using-Excel/ https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
$100 USD en 1 jour
4,7 (177 commentaires)
7,0
7,0
Avatar de l'utilisateur
I have experience in MS Office, VBA Programming, XML, MS Work, Google Docs, SQL, Google Spreadsheet, Data Entry in Odoo, Google Document and other related applications. I believe my capabilities would be perfect for your project. I can complete this job within the necessary period. I have years of encounter in this work and can offer you my past taste work. I will be offering you with all my effort and capabilities. “Moving ahead, I can dedicate 35 hours/week for your job, and my daily hours are negotiable. I’m very empowered to offer my services for your job. Please you can get in touch with me instantly to discuss this place further.” I am mostly online at Yahoo Messenger, Google Talk and Skype. We can discuss there in details, if you are interested. I wish you'd give me this chance. Regards, Mohsan Ijaz
$88 USD en 1 jour
5,0 (67 commentaires)
5,9
5,9
Avatar de l'utilisateur
Hey there, From the sounds of it, you need an Excel expert who can write optimized formulas, VBA code and analyze data to prepare button code for you. Is that sounds about right? I have an extensive knowledge of Excel included VBA. I have also a strong database and analytic background that could be a profit in your project. I've successfuly completed many Excel projects for random clients. Always on time and budget. What is your favorite way to comunicate? Best regards, Rafael Ps. This could be one of my first projects here, so give me the chance to proof that i'm really good business partner. I'm sure that i wont let you down.
$35 USD en 1 jour
4,9 (15 commentaires)
4,5
4,5
Avatar de l'utilisateur
Hi Sir, I can write a marco like you request 1. column 1, delete all duplicate order numbers WITHOUT deleting the rows - Complete first next 3 hours 2. Delete all order numbers on worksheet 1, column 1 that are NOT found on worksheet 2, column 1 - complete next 5 hour. You only paid to me when a macro work. Please send to me your excel file thanks
$55 USD en 1 jour
4,7 (8 commentaires)
3,8
3,8
Avatar de l'utilisateur
Hi, I am an excel expert. I specialize in excel automation using macros. I can start working on the project if you award the project to me now. Thanks and best regards, John
$66 USD en 1 jour
4,9 (16 commentaires)
3,7
3,7
Avatar de l'utilisateur
Hi! I am a freelancer, looking for a job... It is my pleasure to be a part of your project . I am a certified Data Encoder. That's why i think can do your project faster...I like working with sharp deadline with high quality data.. Proficient in MS Office Application... Willing to start immediately... Hard working & Multi-Tasking... Looking forward to work in your project... Thank You! :)
$30 USD en 1 jour
5,0 (4 commentaires)
2,6
2,6

À propos du client

Drapeau de UNITED STATES
Evansville, United States
5,0
8
Méthode de paiement vérifiée
Membre depuis févr. 27, 2017

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.