Find data and copy dynamic range

Solved/Closed
Poojapriya
Posts
6
Registration date
Friday October 16, 2015
Status
Member
Last seen
August 8, 2017
- Dec 12, 2015 at 03:00 AM
 Poojapriya - Dec 16, 2015 at 04:00 AM
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

rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769
Dec 15, 2015 at 03:34 PM
you can use find to locate "a3" then you can use that cell as reference and use currentregion.address
4
Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell
0
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
769 > Poojapriya
Dec 16, 2015 at 03:43 AM
0
ok. thank you!!
0