Hi all,
I am new here and I actually joined this forum because of a challenge I have with data extraction.
I work in a container terminal that has to prepare a transaction report for each ship that we handle. We have an Excel 2007 Macro enabled template for that and each report is saved as a separate workbook in a folder for each month.
We extract specific data from each workbook into one neat row for each ship into a master data file once that workbook is complete, for further analysis and reporting. Currently It takes 30 mins to do this per vessel by manually typing them into the master data sheet. We sail up to 500 vessels a year. Its a lot of time and creates room for errors.
I need a Macro, VBA code, something excel based, to automate the extraction of this info from the separate workbooks into the Master data file such that fresh info lands in a fresh row.
Appreciate your feedback
Ebun
Bookmarks