Spliting the Excel File

Hi All,

I want to read the excel file and segregate it into different excel sheet on the basis of knowledge.Also needs to provide a dynamic path so that if the excel sheets are saved into other system then it can be automatically read by BOT and starts the automation.
Please help.!!

split the data using filter or select activity with data table, connect with map network drive for the required links while saving the excel file in dynamic path