I have a monthly spreadsheet that compares customer order data to my data.
The customer uses their own order numbers. I capture these but also have my own reference numbers.
The customer may place more than one order against the same order number, but I would use new reference numbers for each order. Eg, customer order number 12345 would have my order numbers abcde, fghij and klmnop.
Also, sometimes the customer order numbers have info added, like "12345 /new order", or "45678 / 98723". The information is usually separated by a forward slash. The solution needs to look at all the information and not get "confused" by the forward slash and tell me that reference number doesn't exist!!
I need to summarise the data so that I can tell the customer that these are all my order numbers against each of your numbers.
The solution needs to look at all the information in the customer reference col (C) and not get "confused" by the forward slash and tell me that reference number doesn't exist!!
I would like to return all my order numbers, separated by comma's.
Also, I need to know how to then manipulate the solution so I can use it to return other types of data from the same sheet- eg, customer order date against, order fulfilled date etc.
I can't use a vlookup as I need all the values to be returned.
I don't really know VBA but don't mind using it...I usually have about 1000 lines of data to go through so would really appreciate some help on this!
Example workbook is attached.