Previous Topic Next Topic

Find data and copy dynamic range

Solved/Closed
Poojapriya Posts 3 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!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
Poojapriya
Dec 15, 2015 at 11:28 PM
Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Poojapriya
Dec 16, 2015 at 03:43 AM
see this
https://ccm.net/forum/affich-861811-resize-the-range#p862181
Poojapriya
Dec 16, 2015 at 04:00 AM
ok. thank you!!

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses
Re:Lava A16 mobile restore factory settings code
DEEPUKUMAR -
Krunal -

11 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How to format Lava mobile?
Akum -
Dushyant -

22 responses
Can't join WhatsApp group chat
Matt92 -
vocalkeny -

25 responses