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

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ết bức thư có nội 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?

Thanks for any help