Formulas can be used if you are returning on row/column of data for each
formula you write. but formulas are slow and if you are returning
differetn amount of data each time the workbook is updated.

A better method would be to write a vba macro to perform this task.
People would aruge the fact when macro should be used or formulas should
be used. But if you are returning a LARGE amount of data the formula
tend to slow down a workbook considerably.

Provide more information on the organization of the workbooks and data
so you can get the correct solution.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?userid=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=151851

Microsoft Office Help