VBA: finding data based on values in 2 cells in 2 different rows

[sunilbsrv2k]

Hi all,

I'm trying to get a number from a cell based on the criteria in 2 different cells but in the same column.

This has to be pasted in another sheet, which has got the reference number same as one of the above 2 criteria.

Please help.

Thanks,

 

[sunilbsrv2k]

I am trying to write a code in VBA for the above task.

But "wb" in the code is empty. Could you please throw some light on the mistake in this code:

[FONT=Verdana]Sub mcrCC()[/FONT]
[FONT=Verdana]Dim i, n, m As Integer
Dim shArr()[/FONT]
[FONT=Verdana]Dim rng, arng, rowrng As Range
Dim wb, wb1 As Workbook
Dim ws, ws1 As Worksheet[/FONT]
[FONT=Verdana]On Error Resume Next[/FONT]
[FONT=Verdana]Set wb = Workbook.Open("D:\Sank\C C report - Macros\XHR CC_Site PL_V2.xlsx")[/FONT]
[FONT=Verdana]MsgBox wb.Name
[/FONT]