LinkBack URL
About LinkBacks
Hello,
From worksheet "List" I would like to copy to "Results" columns B, C, D (in "D" will be several values seperated by comma).
In the attachment You can find data and example.
Worksheet "List" will be updating every week.
Hello,
From worksheet "List" I would like to copy to "Results" columns B, C, D (in "D" will be several values seperated by comma).
In the attachment You can find data and example.
Worksheet "List" will be updating every week.
Not as easy as first blush, this macro seems to be giving the desired results:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hello,
Thanks for reply! Is it possible to do not show the same values?
Excample... for this 22LJ620H-ZA.AEKNLBP: AGF76438301,AGF76438301,AGF76438301,AGF76453501,AGF76453501
I would like to see only: AGF76438301, AGF76453501
etc...
Another case... is it possible show only one value if there is more than one same model.suffix?
For example:
This:
22LJ620H-ZA.AEKNLBP AAA74829109 AGF76438301
22LJ620H-ZA.AEKNLBP AAA74829109 AGF76438301
22LJ620H-ZA.AEKNLBP AAA74829109 AGF76438301
22LJ620H-ZA.AEKNLBP AAA74829109 AGF76453501
22LJ620H-ZA.AEKNLBP AAA74829109 AGF76453501
Show as below:
22LJ620H-ZA.AEKNLBP AAA74829109 AGF76438301, AGF76453501 ?
Thank you in advance
As I said, progressively less "easy" as new parameters are added.
This will eliminate the duplicate column C values. As for your second question, when I run the new macro I get those results for that item, so perhaps that issue self-resolved.
Please Login or Register to view this content.
Please Login or Register to view this content.
Works fine. Thank You!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks