How to Copy Filtered rows from excel

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: