Creating formula or macro

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) .
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top