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

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