Đã hoàn thành

Excel Macro array work

I need to modify and sort a group of merged cells on a sheet after some text in one of the cells was modified. With the attached file, I have it setup where if you type in cells K14:P179, the code looks at the string, and if its longer than 50 characters, that merged cells data gets replaced with "See Addendum 1-1" or whatever inspection section is (2-1, 2-2, etc) and the replaced text is moved to the addendum section B247:Q350 and parsed to multiple lines of about 150 characters long. This part works well. What I need is when the customer modify's the lines in the addendum section, and say add 2 or 3 sentences to any of the addendum sections, I need to resize the modified string into lines that fit my max string length allowed and make sure it's sorted correctly. Ultimately, I would like a popup userform to show the complete string of that section and be able to modify it, and then a command button to save the modified string and parse it into rows, properly sorted in the addendum section.

Also attached is a slide show showing what I would like it to do.

Cost of the project not limited to the project cost shown.

Kĩ năng: Excel VBA

Xem nhiều hơn: vba add to array, initialize array vba, vba array function, excel vba dynamic array, excel vba multidimensional array, vba array of strings, array vba excel, vba array redim, Excel macro work, excel macro search replace work, fix excel macro work mac, work home excel macro program, work allocation excel macro, make frontend excel macro, freelance excel macro work

Về Bên Thuê:
( 4 nhận xét ) Reedsburg, United States

ID dự án: #15346205

Được trao cho:


i just went through your job post. it's very interesting to me. If you hire me, I can start working for you right now. Relevant Skills and Experience I am very familiar and strong knowledge of Excel VBA. Proposed Mil Thêm

$25 USD trong 1 ngày
(3 Đánh Giá)

6 freelancer đang chào giá trung bình $54 cho công việc này


Hi, I can code that vba modules quickly for your "array" work. Relevant Skills and Experience Excel/vba since 1997 Proposed Milestones $25 USD - default

$111 USD trong 1 ngày
(2 Nhận xét)

I can do it Relevant Skills and Experience I am good

$25 USD trong 1 ngày
(0 Nhận xét)
$15 USD trong 5 ngày
(0 Nhận xét)
$125 USD trong 2 ngày
(0 Nhận xét)

I have expertise in Excel VBA. Client's satisfaction is my first priority and believe in long-term relationship with my clients. Thanks Relevant Skills and Experience excel vba Proposed Milestones $25 USD - full

$25 USD trong 1 ngày
(1 Nhận xét)