Đã 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 thêm: 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, excel macro work required job work, excel macro make file, bid excel macro work, work mutiple excel macro, excel macro work external application, excel macro doesnt work paste data, macro dont work excel 2000, excel macro fill empty cells

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

Mã Dự Án: #15346205

Đã trao cho:

maximwang8661

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
(0 Đánh Giá)
0.0

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

zu02

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
(1 Đánh Giá)
0.7
geriomk

I can do it Relevant Skills and Experience I am good

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
hokwon

i can do it Relevant Skills and Experience Excel VBA Proposed Milestones $35 USD - 1

$35 USD trong 2 ngày
(0 Đánh Giá)
0.0
$15 USD trong 5 ngày
(0 Đánh Giá)
0.0
$125 USD trong 2 ngày
(0 Đánh Giá)
0.0
axiomswb

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
(0 Đánh Giá)
0.0