Find Jobs
Hire Freelancers

I need some VBA coding for Excel

$30-250 USD

Sürüyor
İlan edilme: yaklaşık 7 yıl önce

$30-250 USD

Teslimde ödenir
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.
Proje No: 13580310

Proje hakkında

7 teklif
Uzaktan proje
Son aktiviteden bu yana geçen zaman 7 yıl önce

Biraz para mı kazanmak istiyorsunuz?

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin
Çalışmanız için ödeme alın
Teklifinizin ana hatlarını belirleyin
Kaydolmak ve işlere teklif vermek ücretsizdir
7 freelancer bu proje için ortalama $80 USD teklif veriyor
Kullanıcı Avatarı
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 1 gün içinde
4,7 (177 değerlendirme)
7,0
7,0
Kullanıcı Avatarı
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 1 gün içinde
5,0 (67 değerlendirme)
5,9
5,9
Kullanıcı Avatarı
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 1 gün içinde
4,9 (15 değerlendirme)
4,5
4,5
Kullanıcı Avatarı
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 1 gün içinde
4,7 (8 değerlendirme)
3,8
3,8
Kullanıcı Avatarı
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 1 gün içinde
4,9 (16 değerlendirme)
3,7
3,7
Kullanıcı Avatarı
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 1 gün içinde
5,0 (4 değerlendirme)
2,6
2,6

Müşteri hakkında

   UNITED STATES bayrağı
Evansville, United States
5,0
8
Ödeme yöntemi onaylandı
Şub 27, 2017 tarihinden bu yana üye

Müşteri Doğrulaması

Teşekkürler! Ücretsiz kredinizi talep etmeniz için size bir bağlantı gönderdik.
E-postanız gönderilirken bir şeyler yanlış gitti. Lütfen tekrar deneyin.
Kayıtlı Kullanıcı İlan Edlien Toplam İş
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ön izleme yükleniyor
Coğrafik konum için izin verildi.
Giriş oturumunuzun süresi doldu ve çıkış yaptınız. Lütfen tekrar giriş yapın.