Dear forummembers,
I'm trying to retrieve certain values from a dataset (horizontally orientated like this).UnList Source.gif
For each column in range O:V I need a list with data from unique customernumber (Custno).
But only:
- IF Artno is not empty
- IF Custno is "123abc" a extra row needs to be added to the unique list which states Custno "456abc" (and Group and Artno with the data from custno "123abc")
I've managed to get the list, only not the unique-part
Here is my code and attached my testfile.
I'm sure this is easypeasy for you but I just can't figure it out. So....help me please...
Please Login or Register to view this content.
Bookmarks