nair.harish
New Member
- Joined
- Mar 2, 2010
- Messages
- 40
Hi
I have a userform with 4 refedit functions, i worked out something like this
Private Sub OK_Click()
Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "RECO"
ActiveCell.FormulaR1C1 = _
"=INDEX('PHO STA JUNE'!C[4],MATCH('7282'!RC[-3],'PHO STA JUNE'!C[-3],0))"
End Sub
but i dont know how to link it to the ok button, secondly
the 4 refedit functions look like this
1) select supplier statement invoice numbers
2) select supplier amount
3) select our invoice numbers
4) select our amount
now what i really want to do is match supplier invoice number and amount with ours and if any numbers not found the invoice number is outputted with the amount saying that the invoice number is incorrect or not there, and if the amount matched with each other after subtracting is not zero, then it is returned separately(a simple reconcilation), right now i work with the index and match simultaneously, if this userform works then it would really be gr8.... can someone help??
I have a userform with 4 refedit functions, i worked out something like this
Private Sub OK_Click()
Worksheets.Add(After:=Worksheets(Worksheets.Count)).Name = "RECO"
ActiveCell.FormulaR1C1 = _
"=INDEX('PHO STA JUNE'!C[4],MATCH('7282'!RC[-3],'PHO STA JUNE'!C[-3],0))"
End Sub
but i dont know how to link it to the ok button, secondly
the 4 refedit functions look like this
1) select supplier statement invoice numbers
2) select supplier amount
3) select our invoice numbers
4) select our amount
now what i really want to do is match supplier invoice number and amount with ours and if any numbers not found the invoice number is outputted with the amount saying that the invoice number is incorrect or not there, and if the amount matched with each other after subtracting is not zero, then it is returned separately(a simple reconcilation), right now i work with the index and match simultaneously, if this userform works then it would really be gr8.... can someone help??
