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.
6 freelancer đang chào giá trung bình $54 cho công việc này
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