I have number of excel files in a folder. each excel file contains 2 sheets, open issue sheet and closed issue sheet. the sheets contain following data start date / end date /issue number.
i would like to know if using an excel macro,
1. combine all excel files => a final new workbook with 2 sheets (opne/closed issue sheet).
2. the sheets should only contain issue numbers,start date, end date( present date will be end date for open issues)...and Number of days/issue opened, in a separate column. the issue information/decription shouldnt been extracted...only issue number's/sart.emd date will be extracted from all excel sheets.
i will add 2 files for sample excel sheets that i will be puting in the folder.
links to the files
View all files for Question ID: 22714894
Direct link to your file