i dont want to use pivot table because there are many other search
criterias based on that dataset and it wont be practical for other
users or when the data range changes over time

it has to be vba code

thanx in advance


--
barkiny
------------------------------------------------------------------------
barkiny's Profile: http://www.excelforum.com/member.php...o&userid=20397
View this thread: http://www.excelforum.com/showthread...hreadid=396461