ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Loop question (https://www.excelbanter.com/excel-discussion-misc-queries/149994-loop-question.html)

N.F[_2_]

Loop question
 
How do I Loop through each row in a range("Values") which is a range that is
changing all the time. I believe
there called dynamic ranges. Loop through each row and in each cell if
theres a value in that cell
get the value in the cell and add the word "found" and do a table in sheet2.

For example:

The code is looping through and finds a populated cell in range ("Values")
I want the code to generate a secondary table say in sheet 2 for instance.
This
table should display :

value found in cell from table 1= "found"
value found in cell from table 1 = "found"



All times are GMT +1. The time now is 08:35 PM.

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