Devam Ediyor

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

Beceriler: Excel, Veri İşleme, Excel Macros

Daha fazlasını gör: 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

İşveren Hakkında:
( 66 değerlendirme ) London, United Kingdom

Proje NO: #29887312

Seçilen:

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 Daha Fazla

1 gün içinde %selectedBids___i_sum_sub_4%%project_currencyDetails_sign_sub_5% USD
(0 Değerlendirme)
0.0

Bu iş için 12 freelancer ortalamada $24 teklif veriyor

(454 Değerlendirme)
7.3
writingapp

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(105 Değerlendirme)
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:"";}" Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(35 Değerlendirme)
5.2
(18 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(19 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)
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, Daha Fazla

$15 USD in 5 gün içinde
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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 Daha Fazla

$20 USD in 7 gün içinde
(1 Yorum)
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 Daha Fazla

$23 USD in 2 gün içinde
(0 Değerlendirme)
0.0
(0 Değerlendirme)
0.0