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.