Macro to paste a specific cells from the known .xlsx to summary.xlsx (in the same folder)

table.PNG

Hi Friends,

I have few excel workbook names in the colkumn A "summary.xlsx" workbook and the column B has to be filled with the value which is in Cell A5 of the reference workbook.
See the snapshot.

Please help.

Thanks and regards,

Amit

Given the following assumptions:
- The first workbook name is in cell A2 of the current sheet.
- When a source workbook is opened, it will open to the correct sheet for the desired cell A5.
Then the following should work:

Please Login or Register  to view this content.

If the assumptions are not correct, you'll need to make adjustments accordingly. Let me know if you need further assistance.