i need your help since i’m new with this UiPath RPA , i’m having trouble to make the following automation process in excel file, can someone help me?
here is my problem:
First, I want to filter the “Status” column to only select the “Closed” description.
(i have filtered the Status column and i did it well)
Secondly, I want to filter the “Date” column to select only the date that matches the date range in “Date Period” (i can’t filter this column)
Thirdly, I want to retrieve data from the “Description” column that has been filtered based on the “Status” column and “Date” Columns, then put the data in Sheet2 into “put the data here” section.
Here is the view of my excel data.