

June 26, 2016

Hello everyone, my name is Maurizio
And my new problem is this:
I would have the diversity of obtaining two lists of items on sheet 1, one in column (A) and the other in column (B)
Therefore in column (A) I can write "Red Table"; "Blue Table"; "Red flower" ; "Blue Flower" etc ...!
Now what I would like to achieve would be to have the last real color entry in color (B)
example if in column (A) I write red table
In column (B) the word (Roso table) should come out but only the red word
thanks
A.Maurizio


October 5, 2010

Hi Maurizio,
I've written some code to do what you want but it may need to be more robust as it checks for the occurrence of a string e.g. Blu within the text in the cell in Col A. If the text in ColA contains a word like 'Blur' then you'll end up with Blu in ColB.
But as I don't know what you'll be typing into ColA, or indeed how the data gets into ColA at all, I'll leave it at this for now, unless you need some more assistance.
You'll find the code in the Foglio 1 module, it's event driven.
Regards
Phil


June 26, 2016

Hello Philip Sorry if I answer you only now for this your help.
But despite the Coronavirus I was very busy with my work.
That said: I must say that as always you have been sublime.
The whole thing is very nice, and true has some anomaly but maybe I also figured out how to fix it all.
So thank you so much
Hello and next.
Sincere greetings from A.Maurizio
1 Guest(s)
