Hi, I want to create a macro to automate my formula every time I entered a job number manually in column A it automate update the formula in column B.
A B
1 job_no Jan-09
2 100018 49,91549
If in cell B2 formula ='M:\job Number\2009-01\[100018- R110104P.XLS]Job_Detail'!D$20
Thanks,
David
A B
1 job_no Jan-09
2 100018 49,91549
If in cell B2 formula ='M:\job Number\2009-01\[100018- R110104P.XLS]Job_Detail'!D$20
Thanks,
David
Last edited: