Find data and copy dynamic range [Solved]

Ask a question Poojapriya 5Posts Friday October 16, 2015Registration date April 4, 2016 Last seen - Latest answer on Dec 16, 2015 04:00AM
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!
See more 
moins plus
you can use find to locate "a3" then you can use that cell as reference and use currentregion.address
Poojapriya- Dec 15, 2015 11:28PM
Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell
rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Dec 16, 2015 03:43AM
see this
Poojapriya- Dec 16, 2015 04:00AM
ok. thank you!!
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!