Creating an array formula in vb
 

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

Creating an array formula in vb
 

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