I have created a XLSM file that import TXT files, clean the importation, merge it into sheet "Analysis" and then apply a conditional formatting on Duplicates Values. I see what I need to work (my columns heading and duplicates PC in Column A with additional information in column B & C). Now to finish my "preparation" for "analysis", I would like to copy / paste the headers and only selected visible rows into a new workbook. Can you help me with that macro?
The new workbook would be name "Analysis - Duplicate PC - yyyy-mm-dd.xlsx" where yyyy-mm-dd would be the current date.
I have attached a sample of my workbook.