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!

Find data and copy dynamic range
Tmobile data check - Guide
Samsung dynamic picture mode - Guide
Data transmission cable - Guide
How to copy data from one excel sheet to another - Guide
Download facebook data - Guide

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

How To Fix Mint Mobile Data Not Working?

Hosted app data will not clear

Unlock safe folder without losing any data

Sir in dynamic duo point is not increasing why

Similar discussions

Subscribe To Our Newsletter!