Need to loop through Sheet and Update another Sheet by way of Macro

  • Good Day


    I have the following code which is breaking after adapting it. Essentially the code is suppose to Loop through Sheet FARJUL and update sheet FARJUN. I am getting the following error when running the macro Runt-Time error '9' - Subscript out of range "outarr(l + 49, n) = inarr2(j, l)"



    Solution was provided at :   https://www.excelforum.com/excel-programming-vba-macros/1358210-copy-data-from-one-to-another-based-on-reference-number.html#post5564320


    Thanks01 FAR - July 2021v1.xlsm01 FAR - July 2021v1.xlsm

  • HI Roy


    On both sheets there is a unique column H which has reference numbers. So I would like macro to lookup each row and if changes are made on FARJUL the macro with update FARJUN

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!