Solved: Match 2 worksheet and reconcile

[tlchan]

Hi there,
I had tried to reconcile 2 worksheets Sheet "Branch" and sheet "Ho" where if the value under column A of two sheets is matched then copy corresponding value under column B of sheet"HO" to column B of sheet "Branch".

I try the VBA from the web and works for short sample but return with highligth error under line RowNo = Application.WorksheetFunction.Match(c, rng2) when work on long data as attached workbook.


Can anybody help ?

[GTO]

Greetings,

I did not test for results accuracy, as I'm sure you already have. While not sure exactly why this struck me, I added a zero to match (to enforce an exact match) and she ran all the way through. It is just a lucky guess on my part if this is it, as I've only used MATCH a handful of times.

At line 11: RowNo = Application.WorksheetFunction.Match(c, rng2, 0)

Hope this helps,

Mark

[tlchan]

Thanks GTO. Appreciate your solution and it works for me.

Thanks:friends:

[GTO]

Hi Tichan,

Well shucks, I'm glad that worked as it was certainly just a lucky guess!

Very happy to help,

Mark