s The tricky part is processing criteria when you have it. What do yo
want to do with it?

actually, after creating the LUTs, i want program to compare the LUT'
criterias against the data cells and display the count of the no. o
cells that matched. As you can see from the attachment, the result
sheet shows 2 result of count: 1 is the result of count from individua
criteria in the LUT and 1 is the result of the combined LUT's criterias
So does this make sense??
Anyone??

y
Just put additional controls on the userform for the user to ente
the
number of LUTS, then you can provide a couple of textboxes for th
user to
enter the details. After each set of criteria is entered, you even
code
would clear the textboxes and prompt (use a label) for the nex
LUTS'
criteria.

can u show an example tom?

--
Message posted from http://www.ExcelForum.com