Macro or piece of code in Excel

Imekamilika Ilichapishwa Apr 14, 2016 Kulipwa wakati wa kujifungua
Imekamilika Kulipwa wakati wa kujifungua

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

Kitambulisho cha Mradi: #10220348

Kuhusu mradi

9 mapendekezo Mradi wa mbali Ipo mtandaoni %project.latestActivity_relativeTime|badilisha%

Imetuzwa kwa:

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 kwa siku 0
(Maoni 146)
6.0

9 wafanyakazi huru wanazabuni wastani wa €23 kwa kazi hii

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 Zaidi

€30 EUR kwa siku 0
(Maoni 259)
7.2
surekash7096

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

€23 EUR kwa siku 1
(Maoni 34)
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 kwa siku 1
(Maoni 0)
0.4
marekhokynek

A proposal has not yet been provided

€24 EUR kwa siku 1
(Maoni 0)
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 Zaidi

€9 EUR kwa siku 1
(Maoni 0)
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 Zaidi

€14 EUR kwa siku 1
(Maoni 0)
0.0