Hello I want to filter a data from excel by applying a filter that would help me to find those rows which begins with a specified string variable. for example see my attached excel file.
Testbook for filter.xlsx (10.2 KB)
here from sheet if i want to filter the data that begins with “b2/” then it should give me the rows which begins with “b2/” and copy that data and paste it in another sheet.
here the value “b2/” comes from a string variable. Please refer the sheet “Filtered Data” for expected output ans “Sheet1” is the Raw Data.