I prefer ADO programming in such cases. You can use SQL query based on data
from few sheets and put result into another sheet.
Even more - if your master sheet will be more than 65536 data rows you can
use access MDB file to store your data.

MaC

U¿ytkownik "egeorge4"
napisa³ w wiadomo¶ci
...

Thanks for the help and all the views!

I think I have an answer:
http://www.mrexcel.com/board2/viewtopic.php?t=217752

Thanks again!


--
egeorge4
------------------------------------------------------------------------
egeorge4's Profile:
http://www.excelforum.com/member.php...o&userid=30259
View this thread: http://www.excelforum.com/showthread...hreadid=552996