Quote Originally Posted by Keebellah View Post
RC[-3] means the cell in the current row with an offset of -3 columns wo if your active cell is D3 then RC[-3] points to A3
And yes, evrytime you open the MISSING.... file it takes time and you think you have all the rows to look at 1048576, well that's a lot.
The code as it is is not good, but without really understanding what you want to do and why the fill of the entire P column, sorry it's all unclear.



Yeah , it was really alot of records.
Thats why i thought of using the macro to automate the steps as it quite tedious to do it manually.
Anyway, thank you for helping me . It took me days to do this as I have never write macro before and I just started learning excel vba.