How to copy that available value for particular row from below table in same sheet?

Help Studio
1

I have a sheet that has 2 tables like Member’s name and Partners name.
In the 1st table, there are 2 members name “Lmn” and “Qrs” has Code as Not Available.
In the 2nd table, the Code is available for the same.
Currently, I have filtered the data, and I found the code is available in the below table for “Lmn” and “Qrs”.
Now I want to paste that code from the below table to the place of Not available(Above table) for “Lmn” and “Qrs”.
Please find attached files.AddCode.zip (32.0 KB)
Can anyone help with this?

2

@Akash_Chavan Please find modified code of yours.

AddCode - Modified.zip (33.8 KB)

3

It is working fine as I required.
Thank you.

1 Like
4

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