Hello guys,
As the title says I need you help. In the below link:
https://dir.nu/61670e621836a
you will find an archive that contains a "master" workbook called "Status" and multiple 01, 02 Handovers.
In the Status workbook you will find a code for loop through Handover files and collect specific data from them.
What I want is to have an additional Excel workbook named "History" in this folder that contains images with Range(A2:I47) from the Handover files. The "Status" workbook is executed once every 12 hours to collect info from Handovers so in additional Excel workbook "History I would want a sheet for every collect that is named based on the following conditions:
1) If the cell J4 from "Status" contains number 1 the sheet should be named: "TodayDate - Day Shift"
2) If the cell J4 from "Status" contains number 2 the sheet should be named:
"(TodayDate -1) - Night Shift"
For me it would be great if images from every Handover file would be one after the other.
Thank you very much and I hope someone can help as this is my first post on this forum!