ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   looping through rows and columns (https://www.excelbanter.com/excel-discussion-misc-queries/135582-looping-through-rows-columns.html)

mattguerilla

looping through rows and columns
 
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

looping through rows and columns
 
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


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com