Hi All,

i need to automate some manual tasks by using macro and need your help to solve it
here i have attached relevant excel sheet and following are the details. ATTACHMENT macro for MM.zip

apply vlookup for column "H" and get the relevant value from Sheet2 "C" column.
here for vlookup function

lookup_values are F3,F4,F5...etc ( number of rows are not a fixed value,it may change-in this example it's 6049)
table_array- table2 F3:H* (*number of rows)
col_index_no - 3
range_lookup- false

then i should fill G,I:O columns as follow

column G = Column Q ( as an example-Q3 is empty and then G3 should also be empty)

if A3=B3(date or string) then I3=S3 and J3=T3 and K3=U3 and L3=V3 and M3=W3 and N3=X3 and O3=Y3 so on for all rows
if A3=B3="Transfer" or B3="Transfer" then I3=S3 and J3=T3 and K3=U3 and L3=V3 and M3=W3 and N3=X3 and O3=Y3 so on for all rows
if A3="Update next week" and B3=any date then I,J,K should be equal to that date and L,M,N,O should be empty
if A3=B3="Update next week" then I,J,K,L should be "TBA" and M,N,O should be empty
if A3=B3="Hold" then I3=TBA and J3=TBA and K3=TBA and L3=TBA others should be empty
if none of them
all I,J,K,L,M,N,O should be empty


according to above logic i need to fill all rows.
as an example i have filled 3rd and 4th rows.
really appreciate your help
thanks very much