V
Vecah
How can I create formula or macro to do following : to search by criteria
(make a list of values) In a range of column in worksheet (i.e. E10:E36) and
if the criteria is match to the cell in range of column, then change data in
a certain row (I10:E36).
Example : in worksheet there is a values in E10=5 and I10= 10 . If I find
by criteria from my list (2,5,7,9) that one number from the list is mach with
E10, than change values in I10=0 .I must repeat that in all cells in range
(E10:E25) .
(make a list of values) In a range of column in worksheet (i.e. E10:E36) and
if the criteria is match to the cell in range of column, then change data in
a certain row (I10:E36).
Example : in worksheet there is a values in E10=5 and I10= 10 . If I find
by criteria from my list (2,5,7,9) that one number from the list is mach with
E10, than change values in I10=0 .I must repeat that in all cells in range
(E10:E25) .