Macro or piece of code in Excel

Completed Posted 7 years ago Paid on delivery
Completed Paid on delivery

Hi,

I have a product export with contact lenses with several values that I need to display differently. I think it is easy for someone who can write a macro, but I don't know how.

I have something like

xxx from | xxx to | xxx interval

-9 | -6.5 | 0.5

The interval means the xxx value is available in values from 'xxx from' to 'xxx to' with intervals of 0.5, so in this case -9, -8.5, -8, -7.5, -7, -6.5

I want that in a column next to that with the values. So:

xxx from | xxx to | xxx interval | xxx available

-9 | -6.5 | 0.5 | -9, -8.5, -8, -7.5, -7, -6.5

Attached is a small snippet of the product list in excel. The columns with the values I need are in capitals, and they are all alike (with from / to)

I would like something I can use with the bigger excel.

Thank You,

Coen

Excel

Project ID: #10220348

About the project

9 proposals Remote project Active 7 years ago

Awarded to:

cgullapalli

Hi, I am good at Excel and vba. Looking forward to work on this project. I would like to discuss further in the chat.

€33 EUR in 0 days
(146 Reviews)
6.0

9 freelancers are bidding on average €23 for this job

jaylancer43

Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among More

€30 EUR in 0 days
(259 Reviews)
7.2
surekash7096

I have the expertise in Excel and can do this task, quickly and accurately. Ready to start work now.

€23 EUR in 1 day
(34 Reviews)
4.7
Rajendra1887

Hello, How are you? I can do this task for you. Please let me know if we can discuss regarding the same.

€24 EUR in 1 day
(0 Reviews)
0.4
marekhokynek

A proposal has not yet been provided

€24 EUR in 1 day
(0 Reviews)
0.0
beltran0404

Hello, Hi I can really help you with this issue and put in the cell values you want. I manage excel very well. I'm available for an interview if you want. If you award me the proyect we can later make your databa More

€9 EUR in 1 day
(0 Reviews)
0.0
sumuhhp

Hello, I am Sumanth from Bangalore, India. I have 5 years of experience in MS-Excel, Data Analysis and automation. This is my first time on this site and hence you can see that I do not have any ratings/testimo More

€14 EUR in 1 day
(0 Reviews)
0.0