Hi,
The goal of my macro is -
For a particular condition of a column, (Field 'Detailed Status' when having a value 'Escalated') copy certain columns to a new Excel worksheet.
Points where I need help is
1. I have been using PasteSpecial Paste:=xlPasteFormats while copying as shown below. But...