Find data and copy dynamic range

[Solved/Closed]
Report
Posts
6
Registration date
Friday October 16, 2015
Status
Member
Last seen
August 8, 2017
-
 Poojapriya -
Hello all,
I would like to find text in one column and copy the range values which is adjacent to the text searched. I've attached the sample image.


for ex, I need to find a3 in column A and also want to copy the highlighted portion(range is dynamic, columns may vary)

Is it possible?

Thanks in advance!

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
you can use find to locate "a3" then you can use that cell as reference and use currentregion.address
4
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768 > Poojapriya
ok. thank you!!