Ok we have a column in a spreadsheet which currently contains anything from a single to up to 3 or 4 different options, for example
Option1, Option2, Option3
Now I need a macro that take this field and creates a new field in the following format
The sections that need sorting is, we will pre-set the number reference, so for example
Option1 = 7157
Option2 = 7156
This then creates the sections you see in the other field
You can see the number after the i: go's up by one for every option, so remember there may be 3 or 4 different ones, so it would need to add this accordingly.
In addition if you see the section
The a:2 represent how many options there are in total, so if there were 3 options it would be
and if 4 options
and so on, so the macro needs to count how many options there are and enter the number here
The field of options can range from 1 to 4 or 5 etc
12 freelancere byder i gennemsnit $24 timen for dette job
Hi, I can help you with your file. I have advanced knowledge of Excel's formulas, pivot tables, charts and visual basic coding. I'm willing to discuss more about your project.