I have a sheet with in column A1:A5000 text.
In columns D1:J5000 numbers.
Some rows in the range D1:J5000 have numbers greater then 100
Is it possible to make a macro that with the ENTER-button jumps to the cell in column A of the row who have a number greater then 100.ENTER-button jumps to the second ceel in columnA of the row who have a number greater then 100 en so on.
I want a macro to easely show me all the rows who have a number greater then 100 in the range D1:J5000
Thanks.
In columns D1:J5000 numbers.
Some rows in the range D1:J5000 have numbers greater then 100
Is it possible to make a macro that with the ENTER-button jumps to the cell in column A of the row who have a number greater then 100.ENTER-button jumps to the second ceel in columnA of the row who have a number greater then 100 en so on.
I want a macro to easely show me all the rows who have a number greater then 100 in the range D1:J5000
Thanks.