How to locate a specific/dynamic cell in excel?

Help Activities
1

Dear Experts

I have a request as below:

  1. Get the last row value from report A (In this case is 4404123978 which hili in yellow)

report A

image
image940×116 11.4 KB

  1. Find the row of this value in report B, then delete rows from row2 to row16(where the found value lay on)

  2. I only need to keep 2 rows which hili in green

May I know how to make it happen?

report B

image
image946×424 55.2 KB

PS: There is no color in above 2 screenshot in orignial files. I just add color for better explaination and understanding

Thank you for your kind advise in advance

Regards

2

@yangyq10,

Use Activities - Get Cell Color this will give you color and you can add your logic as per requirement.

Thanks,
Ashok :slight_smile:

3

@ashokkarale But actually there is no color in the original format, I just add color for better understanding :joy:

4

@yangyq10,

Ohh ok.

In that case, you can use Find/Replace Value to find the desired value in Report B.

Thanks,
Ashok :slight_smile:

5

@ashokkarale But after I find the value in report B, how can I publish the row number of that value in report B? The row number is key thing in this request :laughing:

6

Hi @yangyq10

Can you try below

image
image829×2446 181 KB

Sequence17.xaml (17.3 KB)

Cheers!!

7

@yangyq10

Find/Replace Value will give you range like “A16” from this you can easily extract the row number by Regex like this.

rowNo=System.Text.RegularExpressions.Regex.Match(rangevariable,"[0-9]+").Value
8

read data2 and get row index of table 2 by checking value from table 1 and use that row index in excel or table to delete rows you need

9

Sequence.xaml (16.8 KB)

10

@lrtetala Thank you again!!!
Can you help show me the full coding in this session so that I can verify accordingly?

image
image749×279 30.5 KB

11

@yangyq10

"2-"+System.Text.RegularExpressions.Regex.Match(Foundat,"\d+").Value

Regards,

12

@lrtetala Sorry for the late reply. I keep debuging this morning with your solution. It should be ok.
Thank you again for the strong support :laughing:

13

@chandreshsinh.jadeja Thank you for the detail guidance. Let me keep trying today :smiley:

14

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.