Applied multiple filters on master data and copy/paste to relevant sheets
//This script performs the following tasks
- Move all the records with value 0 in Column K (i.e. Items) in Invoice Worksheet to Exception Worksheet and delete the same records in Invoice Worksheet.
- For Each Value in column Q (i.e. Services), filter the values and move the records to the particular sheet.
- Move all the service sheet Records to Output Invoice Worksheet.