Find Jobs
Hire Freelancers

Excel script

$10-11 AUD

Completed
Posted almost 3 years ago

$10-11 AUD

Paid on delivery
Hello, We have an excel column with a lot of informations, also a price which we need to increase. Here is sample from the text format found in a cell, there are more caracters then this actual sample. We need to find the value next to "price=", where we find a "-" increase the price with 25% ( on the bellow example would be 1210*1.25=1512.5) and replace the inial value. If after = there isn't a "-" we increase with 30%. This should be done as a macro so we can run it anytime we need. Before: 2 fara usi 80x15cm|name=Adauga dulapuri suplimentare,type=drop_down,required=1,price=-1210.000000,sku=,max_characters=0,file_extension=,image_size_x=0,image_size_y=0,price_type=fixed,option_title=Fara corpuri suspendate suplimentare After: 2 fara usi 80x15cm|name=Adauga dulapuri suplimentare,type=drop_down,required=1,price=-1512.000000,sku=,max_characters=0,file_extension=,image_size_x=0,image_size_y=0,price_type=fixed,option_title=Fara corpuri suspendate suplimentare
Project ID: 30914687

About the project

15 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

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:
User Avatar
$0 AUD in 2 days
4.4 (18 reviews)
3.7
3.7
15 freelancers are bidding on average $13 AUD for this job
User Avatar
Hi, would you mind sharing the actual file, so i can see few more samples. I believe this can be automated quickly. If you are interested, feel free to message me and i will help you immediately. Thanks, Milan
$10 AUD in 1 day
5.0 (30 reviews)
4.8
4.8
User Avatar
Hello there Sir/Madam, A competent Excel freelancer with great experience in Excel not limited to VBA, Macro, Graph, Financial Statement etc at your service. I had gone through your requirement and able to help you out with your project requirement for a fraction of cost. I am working with a team of coders under one roof and can able to get help if necessary too. I am low cost, accurate, self motivated, working oriented quick learner. And I can assure you that I can produce most possible accurate project completion for you. I would like to discuss the project in depth Waiting to discuss further... Kind reagrds Amaan.
$11 AUD in 1 day
4.8 (1 review)
3.0
3.0
User Avatar
Hi there, I can give you a formula that will do the job if you want it that way rather than a macro. regards Reuben
$20 AUD in 1 day
5.0 (2 reviews)
1.6
1.6
User Avatar
Hi,Hope you are doing well! I have checked your requirement, yes I can do it, because I already work on similar requirement in past. If you have interested in my proposal, please contact me. I will do my best in order to complete your project. Thanks for your attention. Best regards Faizan Maqbool
$11 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, there. I have read your project description very carefully so I had confidence that I can do it. I am EXCEL MACRO and VBA EXPERT. I have experience over 5 years with the skills you required. So this project you post can be completed excellently for me, I think. If you want me to complete project, then I will work hardly and give you the project that it would have high quality at the time you need for me. Best regards.
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, with pleasure I can take the project. Could you send me more information about it? Send me a file. Kind regards, Robert
$11 AUD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello. This is part of program to find your price. To get full program, please approve my bid Sub Macro1() Dim MyCell As Range Dim MyRange As Range Set MyRange = Range("A1:A1") For Each MyCell In MyRange price_text = InStr(MyCell, "price=") end_price = InStr(price_text, MyCell, ",") begin_price = price_text + 6 Price = Mid(MyCell, begin_price, end_price - begin_price) If Price < 0 Then Price1 = Price * 1.25 Else Price1 = Price * 1.3 End If
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ROMANIA
Tecuci, Romania
5.0
49
Payment method verified
Member since Dec 12, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.