Forum Discussion
Hi, I need Help to replace this formule by an macro please !!!!
7 Replies
Another approach is to use if-then-else statements but if that's the goal then could you provide the cell location of the formula, like (my cell if H9 and will be checking E9,F9) also, is there a range we can take as our basis to know which are the first and last rows? or do you have a defined first and last row?
These "check-ups" come from another table or do you make them from a list which was handed to you?
I use the function, but excel says you can not override 64 imbrication so I would like to replace it with a marco. My problem is In my life I never uses macro.. Even know how to began.. I know nuthing about that.
Also, going by Sergei Baklan's answer, so you are able to update data faster, I've made it into a table so you only use that reference and copy the table to a hidden sheet. The formula is at right from his.
Could you copy_paste the formula and please, what do you want to change it for?
from si to if? or which changes do you want to make?
