Find Jobs
Hire Freelancers

Improve Excel VBA to remove data

$30-250 USD

Dokončeno
Zveřejněno před více než 5 roky

$30-250 USD

Zaplaceno při doručení
The current excel sheet and VBA code checks for column B and Column D. Whenever there is a value in Column B that does not exist in column D, the script removes that row of Column A/B and shifts the next (of those columns ONLY) rows up. For example if D3 does not match B3, then we must delete C3,D3 and E3 and move C4,D4,E4 up. It also does the same if there is a value in column D that does not exist in B. In that case, it will delete that row of column C/D/E and shifts the next row (of those columns ONLY) up. You can see how the script currently works by running the VBA by clicking on "Remove C/D or A/B" button. Note that the second button does NOT work. Now what I want to do is to continue this script so that after we compare Column A/B to C/D/E, we then compare A/B to F/G, and then compare A/B to H/I At the end, the result should be that EACH row will have the same value in columns B, D, G and I (i.e total number of rows will be equal for all columns). Also, sometimes there is a "Error Type Mismatch" that appears. It can be bypassed by simply clicking "OK" and then clicking again on "Remove C/D or A/B" button. However, this is manual and tedious. We need to AVOID this error completely or incorporate a step to automatically ignore it.
IČ projektu: 18563543

O projektu

11 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
Uděleno:
Avatar uživatele
Hello , I have checked the excel file, read your project description and understood your requirement.I have 5 years experience VBA. I am very responsible towards my clients and I can complete task within time with 100% accuracy With Regards, Sai
$50 USD v 1 dni
4,9 (493 recenze)
7,8
7,8
11 freelanceři nabízejí v průměru $86 USD za tuto práci
Avatar uživatele
Hi, I have had a look at the code and can fix it to work the way you desire. Let me know and I can start working on it right away. Regards, Arul
$100 USD v 2 dnech
5,0 (259 recenze)
7,4
7,4
Avatar uživatele
Ok Sure
$100 USD v 3 dnech
5,0 (196 recenze)
7,1
7,1
Avatar uživatele
Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possible time and with the highest quality! From the Excel, of course, familiar. Give me a chance to show what I can do!
$100 USD v 2 dnech
4,9 (215 recenze)
6,9
6,9
Avatar uživatele
Hello? How are you? I have good experiences in "Improve Excel VBA to remove data" as you can see my profile for these (Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic for Apps). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$155 USD v 3 dnech
4,8 (115 recenze)
6,1
6,1
Avatar uživatele
Hello, i am expert in this kind of jobs samples of my excel VBA jobs https://www.freelancer.com/projects/excel/Create-Excel-Spreadsheet-Macro-that/ https://www.freelancer.com/projects/excel/Make-VBA-code-run-itself/ https://www.freelancer.com/projects/visual-basic/Retrieving-data-from-other-different/ https://www.freelancer.com/projects/Excel/Multiple-Entry-Excel-Macro/ https://www.freelancer.com/projects/Excel/VBA-loop-code-sum/ https://www.freelancer.com/projects/Excel/Complete-Some-Advanced-VBA-Microsoft/ waiting your answer Regards
$45 USD v 1 dni
4,9 (106 recenze)
5,3
5,3
Avatar uživatele
I am a Data Entry Expert and proofreading with 15 years of experience. I also have experience in word, PowerPoint and excel. PDF to Word and Excel. My motive is to make my employer Happy without additional charges and time, so please, give a chance please.
$50 USD v 3 dnech
4,4 (64 recenze)
5,2
5,2
Avatar uživatele
Dear Proyect Manager How are you? My name is Esteban, I'm Industrial Engineer and Excel / VBA Expert. I'm new freelance, You can see some of my experiences in my profile. I can solve this problem as well as help you in economic analysis and evaluations, based on regression studies and statistical estimates. I would love to help you in your project and that you can help me earn more points !! Regards
$35 USD v 3 dnech
4,9 (28 recenze)
4,2
4,2
Avatar uživatele
Hello there, I see your project description and understood that you need Excel VBA worker. I'm interested in your project. This task easy for me. I've lot of experiences of Data entry, Data cleaning and Virtual assistant. Please send me a message so that we can discuss more about this project. Thanks
$133 USD v 4 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
"Greetings! According to your stated project description you need an Google sheet and excel expert. We read your job description and understood. Yes, Our experienced service will help you all about MS program. Just send us all of your requirements to start your project. We think no need to talk about the quality because provided work will proved it. We will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
$100 USD v 3 dnech
5,0 (2 recenze)
0,0
0,0

O klientovi

Pochází z UNITED STATES
Boca Raton, United States
5,0
38
Ověřená platební metoda
Členem od led 16, 2008

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.