Spliting the Excel File

Help
1

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.!!

2

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