I gang

Excel macro needed

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

a:5:{s:4:"mode";s:8:"settings";s:12:"global_forms";a:2:{i:0;s:4:"7157";i:1;s:4:"7156";}s:7:"exclude";s:1:"1";s:16:"override_display";s:6:"normal";s:24:"override_final_total_box";s:0:"";}

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

i:0;s:4:"7157";

i:1;s:4:"7156";

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

global_forms";a:2:

The a:2 represent how many options there are in total, so if there were 3 options it would be

global_forms";a:3:

and if 4 options

global_forms";a:4:

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

Evner: Excel, Databehandling, Excel Macros

Se mere: excel vba macro paste adjacent column, excel macro copy data column, excel macro cells column name, excel macro needed, copy column selected data excel macro, refresh spreadsheet view excel macro, excel macro export column text file, excel macro script insert data spreadsheet, excel macro cut paste spreadsheet, browse cell column excel macro, cut value cell contains excel macro, excel macro locks spreadsheet, excel macro increment move column, output column data excel macro, excel macro column sum, excel macro loop paste column, excel macro copying cell column, excel macro find select column paste, vba excel macro cut paste column

Om arbejdsgiveren:
( 66 bedømmelser ) London, United Kingdom

Projekt ID: #29887312

Tildelt til:

darung

Good Day! I have just read your description carefully and understood exactly and can do right now. I have full experience in Excel formula and VBA for 5years. I always do my best to make employer satisfied. Any subject Flere

$30 USD på 1 dag
(0 bedømmelser)
0.0

12 freelancere byder i gennemsnit $24 timen for dette job

(454 bedømmelser)
7.3
writingapp

Hi. I have written many automation Excel VBA macros. Ready to write your project. Will complete within 1 hour

$30 USD på 1 dag
(105 bedømmelser)
5.9
IgeS

Hi there It means that these strings of text are fixed "a:5:{s:4:"mode";s:8:"settings";s:12:"global_forms";a:" AND "s:7:"exclude";s:1:"1";s:16:"override_display";s:6:"normal";s:24:"override_final_total_box";s:0:"";}" Flere

$25 USD på 1 dag
(35 bedømmelser)
5.2
(18 bedømmelser)
4.3
realtechsl

Hi, I have read the project requirements and ready to work. I am Certified MS-Excel professional with 7 years of experience in this field. My Expertise include: Data Analysis Financial Dashboards Financial Modeling Flere

$20 USD på 1 dag
(19 bedømmelser)
4.0
jiansevillejo

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.

$20 USD på 1 dag
(11 bedømmelser)
2.9
artgrid63

Dear, Hiring manager! I have seen your posted job on freelancer and I feel very much interested to work with you. Ihave read things you want. Iconsider perfect match for this job because I have knowledge about ms word, Flere

$15 USD in 5 dage
(0 bedømmelser)
0.0
tatsam254

I am reliable and first i haven't done any job on this platform but that doesn't mean am a rookie. I can work for 8-15 hours a day.

$13 USD in 3 dage
(0 bedømmelser)
0.0
univere

Dear my client, My name is Univere I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 5+ years of experiences in this field that Flere

$20 USD in 7 dage
(1 bedømmelse)
0.0
aeonpoon

Hi, my name is Hao Jun. I am good with technology and familiar with excel which I am confident to get this task complete. Feel free to PM me and I would get back to you in no time. Hope to here from you soon. Thank yo Flere

$23 USD in 2 dage
(0 bedømmelser)
0.0
(0 bedømmelser)
0.0