My data is in column A and each cell of A contains multiple paragraphs. Some cells are empty.
"VBA: Result only one sentence in each row of column B. Then sort by number of matching words. Underline the matching portion and color [same word same color]. Regex required for partial underlining from beginning or end."
Re: VBA: Result only one sentence in each row of column B.
Need to ask your question a bit more fully.
Re: VBA: Result only one sentence in each row of column B.
I have tried to explain it clearly in steps:
Condition1: My data is in column A of sheet1. Each cell of A contains multiple paragraphs. Some cells are empty.
With VBA 1: Result only one sentence in each row of column A in a new sheet named single-sheet. The sheet name single-sheet need to be created by the VBA.
With VBA 2: Then sort sentences by number of maximum matching words in descending order.
Re: VBA: Result only one sentence in each row of column B.
Condition1: My data is in column A of sheet1. Each cell of A contains multiple paragraphs. Some cells are empty.
With VBA 1: Result only one sentence in each row of column A in a new sheet named single-sheet. The sheet name single-sheet need to be created by the VBA.
With VBA 2: Then sort sentences by number of maximum matching words in descending order.
Re: VBA: Result only one sentence in each row of column B.
I assume you are asking someone to develop the macro for you?
Re: VBA: Result only one sentence in each row of column B.
Yes Sir !
Re: VBA: Result only one sentence in each row of column B.
:0ops:
Re: VBA: Result only one sentence in each row of column B.
Need modified/simplified to get my result: (Need VBA code with comments on every line to learn and understand).
My cell data (multiple paragraphs, sentence, word or strings) is in multiple columns and rows of of any sheet. Any where of them can be empty.
With VBA get list of unique sentences or strings in "sheet x". Every time I start the VBA let it save the result from the last empty cell.
Re: VBA: Result only one sentence in each row of column B.
I think you may be better off at a VBA teaching code site. I believe this site is to assist members with fixing/improving the code they've written, not to do it for them.
If I'm wrong, someone may be along to correct me.
Re: VBA: Result only one sentence in each row of column B.
At least I agree with you bob.
Re: VBA: Result only one sentence in each row of column B.
But I need quick help to achieve this seriously.
Re: VBA: Result only one sentence in each row of column B.
Have you considered posting in the hire help section of this forum? :fyi:
Don’t have an account yet? Register yourself now and be a part of our community!
