Report

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 
Helpful
+4
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
Reply
rizvisa1 4482Posts Thursday January 28, 2010Registration date ContributorStatus February 12, 2016 Last seen - Dec 16, 2015 03:43AM
see this
http://ccm.net/forum/affich-861811-resize-the-range#p862181
Reply
Poojapriya- Dec 16, 2015 04:00AM
ok. thank you!!
Reply
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!