Extract data in start from specific cell

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

Hello guys. If I want to extract all the data for only report number a2, how can I specify in UiPath to tell the robot to only extract data relevant to report “a2”.

[jack.chan]

use this
Sequence2.xaml (14.6 KB)
test.xlsx (9.3 KB)

basically i fill in the blank Report Numbers in column A, then i simply filter Report Number = a2

test.xlsx

result

s

[CHAN_Hiu_Fung_Victor_Stud (CHAN, Hiu Fung Victor [Student])]

but no I want to use UiPath to extract a2 and all the relevant data then transfer the data to another document. I want to automate this process. For example, report a2 has 6 items, and I want to extract all the relevant data for a2. like date, and item id, how can I specify to UiPath, as I can change the data, I want to extract everytime. This time is a2, next time is a3. Millions of thanks.

[AJ_Ask]

Hi @CHAN_Hiu_Fung_Victor_Stud

In this case i have added a input dialogue which will ask for report filter

That input we will use in filter to get the relevant report.

if you want data in another excel you can use following

Find attached code for your ref:
Report_Filter.zip (17.0 KB)

Hope this helps