coding for if condition

Hi,

Can some one please help me on this:

Column A Column B
YP0629160051437 -SNG01540Q0045658
NEFT RETURN SNG01540Q0045658

In the above example data, the last ID's are matching, so I need out put as if the row 2 ID is existing in row 1 then row 1 first id (before high fun(-) sign) need to be printed in Column B of row 2.

Can some one please help me on this.

Regards,
Vimala K

Attach a sample workbook showing what your expected output should be.

Here is the attachment.

Can you give more than a single example, enough data to show your typical data format.

I have 30k rows with combination of different id's out of which i gave my requirement in simple way. its hard for me to simplify the data to give an example. i am sorry.

can some one give me the logic to get the id for the requirement so that i can work on the rest of the coding.

Hi !

Attach a before workbook with all possible cases. According to this workbook, attach too an after workbook for expected result …

Hope this attachment helps you to explain my requirement

Much better. And in no way does your new sample match what you described in your initial post, hence the real sample requirement.

I'm sure someone will now be able to help you.

Thank you so much

can some one please help me on this

As a beginner starter (as all is yet in VBA inner help …) :

PHP Code: 

Sub Demo1()
        Dim R&, S$(), Rg As Range
        Application.ScreenUpdating = False
    With ActiveSheet.UsedRange
        For R = 2 To .Rows.Count
            If .Cells(R, 4).Value = "Debit" Then
                S = Split(.Cells(R, 3).Value, "-")
                Set Rg = .Columns(3).Find("Invoice Reversed for " & S(1), , xlValues, xlWhole)
                If Not Rg Is Nothing Then Rg(1, 3).Value = S(0)
            End If
        Next
    End With
        Set Rg = Nothing
        Application.ScreenUpdating = True
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

ok will try and get back to you

Hi Marc,

I have tried this code on my data. and my data is having 20k rows. but now i am facing the error as below:

Run-time error 9:
Subscript out of range.

May i know how can i fix this error.

regards,
Vimala K

Try first with post #8 attachment …