Please help very urgent

J

Jeff

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))
Click to expand...
Click to expand...
 
Top