- 10% Paid to OzGrid?
- Yes
I am having an issue with this report and would like some changes made. I would like the report to look like the attached example, CFS on Hand Report, after ran, with no borders lines between MAWBS, and no open Spaces. For your review here is the notes I have made. I have several files in a folder on my desktop like the 2 examples Ever Eagle, and OOCL. all files will have a different number of rows from 13 up to row 39. The other workbook “CFS On Hand” Is a report file. I want to place this file in the folder with the files and when a user selects it a message box come up asking if they want to create a new report. Selecting “YES” will activate the macro to open each file in the folder and look for a date in cell “H4” in each file. If no date in that cell, skip that file. If a date is in that cell, look for any cells that are blank in any row that has Data in G13 thru J39. And copy that Row, up to Column “P”, over to the Report File. Each file can have a different number of Rows with Data up to Row 39. In the 2 Example File it would skip the OOCL file as no Date in in Cell H4. But it would copy over row 15 in the Ever Eagle file as it has open cells in the rows with data, and has a Devan date in cell H4. Needed Results As shown in the example. After opening each file and running the macro it would save the report in the file as CFS ON HAND REPORT – and the current date. Please let me know if I need to make another post? Please see the notes below and let me know. Thank you.