I have a table for work that has 17 columns of information and each row represents a different contract. The columns contain information such as the date the contract was sent out, customer, salesperson, status, etc.
Is there a way to pull data from the main table into other worksheets based on certain criteria? For example I would like Sheet 1 to contain the master table with every contract and Sheet 2, 3, 4, etc. to have smaller tables that have only the contracts that pertain to Salesperson A, B, C, etc. I would like to be able to add contracts as they come in to the master table and have that information automatically show up on the pertinent sheets.
I found a way to do this with array formulas but array formulas are slow to calculate. This is the main piece of code the pulls the RC location of the information I want from the masterlist. Based on this location, I then use other formulas to copy the data from the master into the smaller tables.
=IF(ROW()-ROW(CQ)+1>ROWS('Master.xls'!LST)-COUNTBLANK('Master.xls'!LST),"",(ADDRESS(SMALL((IF('Master.xls'!LST="Salesperson A",ROW('Master.xls'!LST),ROW()+ROWS('Master.xls'!LST))),ROW()-ROW(CQ)+1),COLUMN('Master.xls'!LST),4)))
Thanks for your help.
Bookmarks