Creating an array formula in vb

[ram]

I have two tables with a one to many relationship

Table A

Agent ID Agent Name Commission Date Total commission


Table B

Commission Date Agent ID Commission


Currently I have an array formula in the Total commission column (table A)

That sums all commission when the agent ID and commission date in table B
match the agent ID and commission date from table A

When I make updates to the spreadsheet it runs very slow.

Is there away to accomplish this task with VB?

Thanks for any help

[lmn55378]

If you don't mind adding in your sheet a pivot table summing commission
by agent ID and by Comm Date. Your goal could be achieved faster and
more efficiently than writing a VB code unless you don't have many data
in your table B.

DLN.
ram vi=E1=BA=BFt b=E1=BB=A9c th=C6=B0 c=C3=B3 n=E1=BB=99i dung:
> I have two tables with a one to many relationship
>
> Table A
>
> Agent ID Agent Name Commission Date Total commission
>
>
> Table B
>
> Commission Date Agent ID Commission
>
>
> Currently I have an array formula in the Total commission column (table A)
>
> That sums all commission when the agent ID and commission date in table B
> match the agent ID and commission date from table A
>
> When I make updates to the spreadsheet it runs very slow.
>
> Is there away to accomplish this task with VB?
>=20
> Thanks for any help