Hello
I have file name(OUTPUT.xlsm) and file name(STOCK.xlsm) and both files are existed in folder(REPORT) in "D:\Users\MUSSS\Desktop\REPORT"
in OUTPUT file contains SUMMARY sheet should populate value in B4 from the last cell contains numeric value in column H in STOCK sheet for STOCK file , every time run the macro should replace the value in B4 in SUMMARY sheet for OUTPUT file.
thanks