VBA Macro to extract data from every file in a folder and copy data into the open workbook

[snmarar]

Hi All,

I am looking to write a VBA code,

• to extract a couple of cells, DATE and AMOUNT, from each workbook in a folder
• cells containing DATE and AMOUNT are located in "Sheet 1" of each workbook, in cells C4 and G8
• workbook names are similar in nature, for example “F1 JAN 02.xlsx”
• finally, copy and paste DATE and VALUE in
  cells A4 and B4 respectively in ​
  Sheet 1 of the open workbook “Summary.xlsx”

Your assistance in this is greatly appreciated.

Thanks and regards,
Sanjeev.

 

[snmarar]

gallen,

Any thoughts on my question?

Thanks and regards.

 

[gallen]

Thank you for your response.

Apologies, I should have provided you more details.

Basically, each workbook has a sheet with a set of dates and corresponding amounts. Workbooks reside in a folder. That is, Sheet 1 has A4:A10 with dates and B4:B10 with amounts.

I want to copy dates and amounts from each workbook and copy them to an open workbook.

Hope this helps.

Thanks and regards.

So as well as C4 and G8 you'd like A4:B10 copying over too?

Would these go after C4 & G8?