Log In
Register
Home
June 26, 2016
Offline
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
June 26, 2016
Offline
I just want to insert my Test File created with multiple Macros, but that I would like to implement for any row I write something in column (a) and that it is transformed into the same row of column (B)
Thanks
October 5, 2010
Offline
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
Offline
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)
