Macro for IF THEN conditions with Dynamic row range

[rsami]

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

[JasperD]

Hi rsami,

try this :

Please Login or Register  to view this content.

Please click the * below if this helps

[rsami]

Hi JasperD

sorry for the late reply.
thanks very much for your help and it works perfectly.
i added you Reputation

thanks again