Check one of your other threads.

mattguerilla wrote:

Hello,

Can someone show me the code which would allow me to search through a number
of rows and columns, to identify a criteria. Each time the criteria is
found, 1 is added to a variable. When the variable reaches a set number, the
search moves to a different column.

This would allow me to allocate people to jobs according to their first,
second, third choice etc, without resourcing too many people to a job.

can you help? I have very little experience, but am usually able to see
what is happening in the code and expend on it to take care of more elements.

kind regards,

Matt

--

Dave Peterson