Macros Required

$10-30 USD

Completed

Posted about 6 years ago

$10-30 USD

Paid on delivery

I need 2 Macros in the attached CSV file which should run both in Apple and Windows environment Macro 1 If there are multiple EAN's in column Streepjescode then it should paste the 2nd EAN in the next line alongwith all the other details from that line and same is the case if there is 3rd or 4th EAN also Macro 2 For last column URL Miniatuur Afbeelding It will take the input string which I will enter such as[login to view URL] And after that it will add the EAN code from Streepjescode column in that line and after EAN code it will add .jpg Example [login to view URL] Note: Both Macros should merge and run together and gave me result in .CSV file The zeros should keep for EAN it should always be 13 digits and if the EAN code is less than 13 digits then it should add zeros in the start of EAN code in order to make it 13 digits.

Excel

Visual Basic

Visual Basic for Apps

Excel VBA

Excel Macros

Project ID: 24327488

About the project

5 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. Willing and looking forward to working with you. Thank you, Regards.

$40 USD in 2 days

5.0

(153 reviews)

6.8

5 freelancers are bidding on average $53 USD for this job

@sergiuloghin

Hello! I can create the macros in 1-2 days maximum. I am available now. I will start as soon as you award me the project. Thank you!

$110 USD in 2 days

5.0

(323 reviews)

7.9

@bouslimi1979

Hi, I ll code the 2 macros. You will copy/paste the data you already have in the new Excel with macro. Also enter the URL you want to have. Click a button, and you will get the results (new row for each EAN) and also the URL of the images in the second tab. So you can save it as csv for xlsx or whatever you want. I m ready to start and to finish in less than 24h. Thanks

$45 USD in 1 day

5.0

(306 reviews)

7.8

@mrbrave

HI, I am experienced macro developer capable of developing macros to work on both Windows and mac environment. I will develop macro, which will on run ask you to select input csv file. Once selected, it will complete process and create file in required format. If you like, you can run both macros at the same time or run one after another. Thanks

$22 USD in 1 day

4.9

(288 reviews)

6.9

@shahinrahimi

Hi, I did lots of projects like this and can make these two macro work together and will output the result in CSV format. and also it will work on both environments as you required I have rich experience in VBA-Macro(Excel, Powerpoint, Access Word, Web scrapping, API, ....), and I do my best to save your time and pocket. Please feel free to contact me. Services: # Accuracy # Customer satisfaction is my first "Priority" # Time Commitment # Availability Thanks, Shahin

$50 USD in 1 day