Excel filter for multiple selection

Help Activities
, ,
1

PMDC.xlsx (7.7 MB)
I have PMDC file. In PMDC1, I have to apply the filters to column L for the values 1000002537, 1000001235, 1000004354, 1000004811. After that go to cell B3 of PMDC2 and apply filters for these values. Then Copy the rows from PMDC2 from row number A8 to end of the excel PMDC2 and Paste it in another excel…

A dropdown filter menu in a software interface displays options with checkboxes, where one option labeled "1000001235" is selected, and a search field contains the input "1000001." (Captioned by AI)
A dropdown filter menu in a software interface displays options with checkboxes, where one option labeled "1000001235" is selected, and a search field contains the input "1000001." (Captioned by AI)304×159 2.85 KB

Use Add current selection to filter

2

Hi, @Omkar_Shete2

Excel filtered cells can be problem. It’s difficult

3

Can we use send hotkeys… If yes, Then How?

4

@Omkar_Shete2,

I would advise to use VBA Macro for filtering the data. Just record the macro and use the VBA code using Invoke VBA activity.

Refer this.

5

you can use filter datatable activity it should works

6

@Omkar_Shete2

Ok. Before send Ctrl+shift+L. remove filtered cells. After use filter datatable activity

7

Hi @Omkar_Shete2

Please try the following steps:

Read PMDC1:
Use the Excel Application Scope activity to open the PMDC1 file.
Within the scope, use the Read Range activity to load the spreadsheet data (without headers).

Apply filter to PMDC1:
Use the Filter Data Table activity to filter column L by the values: 1000002537, 1000001235, 1000004354, 1000004811.

Read PMDC2 and apply the filter:
Use another Excel Application Scope to open PMDC2.
Use the Select Range activity to select cell B3.
Use the Filter Table activity to apply the same filter to PMDC2 in cell B3.

Copy rows from PMDC2:
Use Read Range to read the rows from A8 to the end.
Use the Copy activity to copy the filtered rows.

Paste into another Excel file:
Use a new Excel Application Scope to open the destination file.
Use Write Range to paste the copied data.

8

Hello, Thank you for your Valuable reply… Can u plz send UiPath workflow for the same… Since i am getting trouble in selecting multiple values in Filter datatable

9

Will u plz send Workflow for the same