Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
creating an array | New Users to Excel | |||
Creating an Array Formula | Excel Programming | |||
Tricky array formula issue - Using array formula on one cell, then autofilling down a range | Excel Programming | |||
Creating an array | Excel Programming | |||
Returning an Array as part of creating a cell formula | Excel Programming |