Hello
Is it possible to replace multiple comma separated values in excel cell by values in reference column?
Please refer the attachment.
Example
If I type A2, A5 in cell C2 then it should replace the value as Apple, Dog.
Hello
Is it possible to replace multiple comma separated values in excel cell by values in reference column?
Please refer the attachment.
Example
If I type A2, A5 in cell C2 then it should replace the value as Apple, Dog.
To Sheet1 code module
![]()
Please Login or Register to view this content.
I guess, code proposed by Jindon can be used like this...
![]()
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Not good enough![]()
Please Login or Register to view this content.
e.g
xxx100000000000000000000000
If you want to restrict to A2:Ax, this should be good enough
![]()
Please Login or Register to view this content.
Last edited by jindon; 03-05-2018 at 06:02 AM.
this activates userform if any cell in column C is selected
Kind regards![]()
Please Login or Register to view this content.
Leo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks