Update another Excel's column from a Macro enabled Excel

[LesliePrabakar]

Greetings all.

I am looking for help updating an Excel column through a macro (enabled in another Excel file).

Procedure:
Step 1: Open 'CALC. VOLUME - MACRO.xlsm' macro enabled file
Step 2: Click the button 'UPDATE VOLUME (VOL * 1000)' => Need code
Step 3: 'Fruits and Volume.xlsx' file's B column to be updated with the formula, saved and closed with a message as 'Updated and Saved'.

Operation procedure.png

Expected one.png

Help appreciated in advance, thanks.