hello,

i need to automate some manual works using Macro.
here i have attached the relevant excel sheet : if conditions.xlsx

here number of rows are not a fixed,it may change day by day and i have to run macro every day.since macro should identify the number of rows (that's the most difficult part for me with my little macro knowledge)
let assume that row index is i (ith row)

if Bi="IH"
then
Ii=Si , Ji=Ti ,Ki=Ui,Li=Vi ,Mi=Wi , Ni=Xi ,Oi=Yi

if (date of Ai= date of Bi)
then
Ii=Si , Ji=Ti ,Ki=Ui,Li=Vi ,Mi=Wi , Ni=Xi ,Oi=Yi

if Bi= "Transfer"
then
Ii=Si , Ji=Ti ,Ki=Ui,Li=Vi ,Mi=Wi , Ni=Xi ,Oi=Yi

if Bi= "Hold" or "Update next week"
then
Ii=Ji=Ki=Li="TBA"

if Ai="Update next week" and Bi=Di
then
Ii=Ji=Ki=Bi and Li="Achievable"

else

I,J,K,L,M,N,O should be empty cells(no need to change )


hope i will get a help from you to overcome this problem
thanks very much