Previous Topic Next Topic

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

Answer 1 / 1
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
Thank you

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

CCM 2942 users have said thank you to us this month

Report

Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell
Report
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
 768 > Poojapriya
see this
https://ccm.net/forum/affich-861811-resize-the-range#p862181
Report

ok. thank you!!
Ask a question