Hi @hrana4375
As of now no in-built features in PAD to filter data in spreadsheet.
Here are alternative options:
#1. Write a macro that filters this data and call this macro from PAD - Easiest
#2. Use "Read from Excel Worksheet" to read the data into a datatable and then loop through the table. Whenever a value is found that matches the filter criteria(s), then read that row from the table and write to another worksheet - Going to be time taking due to the looping particularly if there are large number of records. Would not recommend.
#3. Using Sendkeys on the Excel filter menus and buttons - should be the last resort. Sendkeys not always reliable.
