I am facing an issue with the table in excel sheet . I need to filter data in column 1as i getting the output but it’s copying and pasting it into another sheet, we need to separate data for the main sheet .(Sheet2 ) Attaching the excel file please check it . Sheet 2 In this main sheet after …

How to filter column values in excel using Filter data table activity

jack.chan (Jack Chan) September 28, 2022, 4:08pm 10

use write range in sheet2 with filter

ReadRange.Select("[Number]<> 1 ").CopyToDataTable

Topic		Replies	Views
Filtering excel on Column value Activities excel , orchestrator , activities , studio	11	888	December 17, 2022
Deleting rows from a sheet after filtering Help excel	34	7551	March 28, 2018
How do I Filter Excel COLUMN Help	32	9507	July 19, 2019
Deleting filtered data in column Studio studio , question , activities_panel	3	364	December 21, 2023
Filter column name and copy in new Excel sheet Studio datatable , excel , activities , question	3	1324	April 1, 2020