E
exploringmacro
Hello,
Can somebody help me.
I'm creating a macro, wherein, I have a workbook with Sheet name "Finishes
Checklists" (see below data example), I need to run the report using Advanced
Filter, where all rows with "N" will only show on the report, but the report
must be on a new workbook then will prompt the user to save that workbook.
FINISHES Checklists Template
A B C D
(Column)
Location Item Completed Defects
Description
Y/N
Dining Ceiling N W5 - damage
Lobby Wall Y
FINISHES Report (after running Macro, on new workbook)
A B D (Column)
Location Item Defects Description
Dining Ceiling W5 - damage
Thank you.
Can somebody help me.
I'm creating a macro, wherein, I have a workbook with Sheet name "Finishes
Checklists" (see below data example), I need to run the report using Advanced
Filter, where all rows with "N" will only show on the report, but the report
must be on a new workbook then will prompt the user to save that workbook.
FINISHES Checklists Template
A B C D
(Column)
Location Item Completed Defects
Description
Y/N
Dining Ceiling N W5 - damage
Lobby Wall Y
FINISHES Report (after running Macro, on new workbook)
A B D (Column)
Location Item Defects Description
Dining Ceiling W5 - damage
Thank you.