Need help to look values of the respective sku in different column

Re: Need help to look values of the respective sku in different column

Can't work with pictures.
Upload sanitized Excel file.

Re: Need help to look values of the respective sku in different column

Trying to understand "create pain in my brain"

My apologies if English is not primary language!

Re: Need help to look values of the respective sku in different column

Put Headers in a new sheet (row 1) and run this (adjust Sheet reference to suit)

Option Explicit


Sub ArrangeData()
Dim wsRD As Worksheet, wsSD As Worksheet, i As Integer, lRow As Long
Dim rPN As Range, rD As Range, rHd As Range, rC As Range, rC2 As Range, rD2 As Range, rD3 As Range
    Set wsRD = Sheets("Sheet1")
    Set wsSD = Sheets("Sheet2")
    Set rHd = wsSD.Range("b1", Range("b1").End(xlToRight))
    wsRD.Range("a2", wsRD.Range("a" & Rows.Count).End(xlUp)).Copy wsSD.[a2]
    Set rPN = wsSD.Range("a2", Range("a" & Rows.Count).End(xlUp))
    For Each rC In rPN
        Set rD3 = wsRD.Range("a2", wsRD.Range("a" & Rows.Count).End(xlUp)).Find(rC, , xlValues)
        lRow = rD3.Row
        Set rD = wsRD.Cells(1).CurrentRegion.Rows(lRow)
        i = 1
        For Each rC2 In rHd
            Set rD2 = rD.Find(rC2, , xlValues)
            If Not rD2 Is Nothing Then
                rC.Offset(, i) = rD2.Offset(, 1)
            End If
            i = i + 1
        Next
    Next
    wsSD.Columns.AutoFit
End Sub

Workbook attached to show working.

Re: Need help to look values of the respective sku in different column

http://www.mrexcel.com/forum/e…sku-different-column.html

Re: Need help to look values of the respective sku in different column

JohnCleary

Thanks for picking up on the crossposting.

michellejames

If you are going to post the same question on more than one forum you MUST include a link to all other postings with your question. This saves people wasting their time working on a solution for you when the question has been answered elsewhere. You did agree to do so when you agreed to abide by Ozgrid's rues when you first registered!

If my solution works for you please edit your post on MrExcel with a link to this thread and mention problem solved.

Re: Need help to look values of the respective sku in different column

Thanks johncleary.... Seems like you are the new world police, for excel forums at least

michellejames --- you MUST state if you have posted your question in other forums. This is part of the rules you agreed to when you signed up. It prevents people from answering a question that might already be answered elsewhere.

Regards,
Ger