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.
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 in 1 day
4.9 (493 reviews)
7.8
7.8
11 freelancers are bidding on average $86 USD for this job
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!
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.
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
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.
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
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
"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."