tlchan
11-16-2008, 06:26 AM
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 ?
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 ?