Hello,
Can anyone please help me to transform this function into a VBA macro - it
is to be included in an existing VBA macro - that would run this
function from row F3 in file "BIllable Jobs" to the next empty row in column
"C"

=INDEX([VBPA.xls]Sheet1!$D$1:$D$50000,
MATCH(1,(INT(D3)=[VBPA.xls]Sheet1!$A$1:$A$50000)*("BP"=[VBPA.xls]Sheet1!$C$1:$C$50000),0))

--
Regards,
Jeff


--
Regards,
Jeff