Quote Originally Posted by mperrah View Post
If we know the ranges of the data source and the function to manipulate it and the destination, this can be done in VBA or formulas. Excel has some powerful tools built that can work super fast. But sometimes a little finese is required for more complex manipulating
i cant put a range name in (well i dont think i cant) as Agency Contract sheet has an advanced filter on it