Tricky macro needs to be created based on the steps given in excel sheet

knowledgetrans

New Member
Joined
Jul 22, 2016
Messages
6
Dear Experts,

I wish to know how can I split a paragraph in different cells - one below the other. Catch is when a sentence ends with a full stop and space, question mark, punctuation mark or tab, the next line should appear in next cell. Also, the numbering should be altered as shown in attached example. Also, third column, if having any text, should also be split.

Please suggest how this can be done!

the entire case has been described in excel... please check the excel uploaded at [TABLE="class: cms_table, width: 100%"]
<tbody>[TR]
[TD]Download link
https://we.tl/ILbiil8qjs [/TD]
[/TR]
</tbody>[/TABLE]


I think you will have some doubts. Please feel free to ask.

In the final result, we need to do the following.
1. Break cells in Column A and C - this you have done before.
2. Work on numbering in Column B - this also has been done by you.
3. We need the colour also copied in Column B
4. We need to remove duplicates in Column A -> but catch is that sequence of colours should be Golden, Green and Grey cells at bottom.
5. Need to calculate word count basis the 'colour of column B' and 'word count of column A'
6. DNT terms to be highlighted in RED
7. Glossary Terms should appear as in the example.

Will be grateful if you can help with macro.

Regards,
Rahul
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Forum statistics

Threads
1,226,730
Messages
6,192,705
Members
453,748
Latest member
akhtarf3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top