Skip to main content

Hi All, 

 

I am using Excel advanced - Filter action to filter the rows with a condition, it is working fine, but now i need copy filtered records into another worksheet. how do i copy filtered rows from an excel sheet?

 

Regards,

Achyuth

That’s an interesting question, Achyuth121 !

I think the following community members may be able to help 

@Marc Mueller 

@Vatsy 

@Zaid Chougle 

@Tamil Arasu10 

@madhu subbegowda 

@jackson 

@HARUN KUMAR 

@NewTushitha 

@Azhar Hossain 

@kdil 

@Padmakumar 

Hi ​@Achyuth121 

1. Use "Filter" Action

  • Action: Excel Advanced → Filter
  • Input: Source worksheet and filter condition(s)
  • Output: Assign the filtered result to a Table variable (e.g., $FilteredRows$)

2. Switch to Target Worksheet

  • Action: Excel Advanced → Activate Worksheet
  • Input: Target worksheet name (e.g., "FilteredData")

3. Write Filtered Data to Target Sheet

  • Action: Excel Advanced → Write to Worksheet
  • Input:
    • Table variable: $FilteredRows$
    • Start cell: e.g., A1
    • Include Headers: Yes

Make sure the target sheet exists; if not, create it beforehand using Create Worksheet.

High level summary for you:

Step Action Purpose
1 Filter (Excel Advanced) Filter source sheet data
2 Activate Worksheet Move to destination worksheet
3 Write to Worksheet Paste filtered data (with headers)

Reply


Terms & ConditionsCookie settings