Excel + Python using Filters #52

https://youtu.be/-eqyjTX--kQ Leave a thumbs up https://github.com/XanderGr/EXCEL Leave a 5 star Share with mates and your family First, let's understand what the code does. This script helps you filter through a large Excel file and save only the data that meets certain criteria into a new Excel file. The original Excel file is converted into a CSV file and then filtered based on a specified column to search for certain criteria. The sensitive information column is also filtered to remove empty cells, and then saved as a new Excel file with the current date. To use this script, you'll need to replace the following variables: * COLUMNTOFILTER: Replace this with the name of the column that you want to filter on. * Error 1, Error 2, Error 3: Replace these with the criteria that you want to filter for. * Sensitive Column: Replace this with the name of the column that contains sensitive information. * COLUMNTOSEARCH: Replace this with the name of the column that you want to search for. * SELECTED_CRITERIA: Replace this with the specific criteria that you want to search for. Make sure you save your Excel file in the same directory as the script and update the file_name variable to match your file name.