If e.DataCol.Name = "最新进度" AndAlso e.DataRow("最新进度") = "放款" Then
Dim nma() As String = {"进件日期","分类","部门或渠道","客户经理","客户名字","客户手机号","产品名称","期数","进件额度","批款日期","批款额度","放款日期","放款额度","最新进度","备注"} 'A表数据来源列
Dim nmb() As String = {"进件日期","分类","部门或渠道","客户经理","客户名字","客户手机号","产品名称","期数","进件额度","批款日期","批款额度","放款日期","放款额度","最新进度","备注"}'B表数据接收列
Dim dr1 As DataRow = DataTables("已放款").find("客户名字='" & e.DataRow("客户名字") & "'") '自己改为合适的查询条件
If dr1 Is Nothing Then
Dim dr As DataRow = DataTables("已放款").AddNew
End If
For i As Integer = 0 To nma.Length - 1
dr(nmb(i)) = e.DataRow(nma(i))
Next
End If