Find unique value in column and return multiple values

I have Worksheet 2 that contains data. Row 5 contains the Manufacturer and Column A contains the product name. The remainder of cells contain a value. I need to start by looking for the lowest value in column B. If that lowest value is unique I want to return that value along with the header and product name to a row in Worksheet 1. (We'll say cells A1:C1). I then want it to look in column D of Worksheet 2 and repeat the process. If it didn't find a unique low value in column C, I would want the results from column D to appear in cells A1:C1. I would need this process to continue until it reaches column R.

I've wordsmith-ed my searches many times but have yet to find something that will help me with this. Is this possible to perform using VBA code?

I've uploaded a dummy spreadsheet. The first worksheet shows the results I should get back. The second worksheet shows the data. I've highlighted in yellow the items that are the lowest unique value in that column. The items in red are lowest, but duplicated in that column so I would not want to see them. (Normally they would not be highlighted in color)

Post a sample workbook with sample data and sample results from that data so we can see what you're doing and how you are making these decisions.

Click GO ADVANCED and use the paperclip icon to post up a desensitized copy of your workbook.

Like so:

Please Login or Register  to view this content.