wasnt sure how to go about this but i need a macro for the instructions below
in column k if a cell has the word "out" and the cell in column O
is empty then change the current word in column M to unresolved
once the above rules have been executed then
any cells that are empty in column O copy the data from column N paste it in the corresponding empty cell in column O
and high light It yellow
FYI the amount of lines differ every day anywhere from 45k to 700k (sheet name is Page1)
in column k if a cell has the word "out" and the cell in column O
is empty then change the current word in column M to unresolved
once the above rules have been executed then
any cells that are empty in column O copy the data from column N paste it in the corresponding empty cell in column O
and high light It yellow
FYI the amount of lines differ every day anywhere from 45k to 700k (sheet name is Page1)