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
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
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.
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
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.
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