VBA expert to Write Excel Script
$50-100 USD
Bezahlt bei Lieferung
Make sure all your code is commented because I am in a hurry and I want to finish this quickly.
1. [login to view URL] in this scenario take data in B column and add them all into the field B138 with ";" separation. (example: Loop;Open Loop;Padded Open Loop;Padded T-Bar)
A) if there is something like this [login to view URL] then make sure it does the #1 function only to the options that belong to the associated A column value. (notice the separate colors [login to view URL])
* So for this 2 VBA scripts is what I need.
2. Then another script that will be based on 2 excel files: fileA and fileB (if you can't do this with different excel or sheets then consider having all date in one sheet but in different columns, obviously)
use Column A in fileA as a way to connect to Column X in fileB;
if column A and X data matches then copy all the data in the same row from column X to the infinite right.
Maybe I confuse you with this explanation, but here is an example; let's assume we have in fileA we have these columns:
A) Phone Number (as identifier)
B) Name
C) Surname
D) Address
and I have fileB with columns:
E) Phone Number (as an identifier)
F) country
G) zip
H) Car Brand
Now, I want to be able to match the entire row and column from excel fileA column A with fileB column E.
After we match them we need to copy everything from column F,G,H of fileB and move it to FileA and paste it in columns E,F,G.
So, we copy paste everything including titles and all the column from original file, but we make sure it is also matching in the same row as the phone number (identifier).
* For this I need 1 VBA script that does it all.
Projekt-ID: #7760085
Über das Projekt
Vergeben an:
Hi, I can do the job, VBA expert, I am work with VBA in office automation, the second part of the #1 is not clearly Regards Diego
7 Freelancer bieten im Durchschnitt $64 für diesen Job
Hello, I am able to Complete this in just few hours with full accuracy and all requirements fulfilled. Please message me If you want discussion related project and want to know about my qualifications. I have 1.5 Mehr
Hi Dear, Your explanation is good and easy to follow. Please contact me for your project. Thanks.
As per your Sample Data work will be completed with in 3 days.. send me the sheets. Mostly I will use Formulas to complete the work and write a minimal VBA program so that you can apply it easily. Jithendra.K
Hi, I have 8 years of experience in developing EXCEL VBA based solution. I can develop the macros with customization and dynamic behaviour. Will include requirement comments. Am working form INDIA UTC+5:30, wil Mehr