Find data and copy dynamic range

Solved/Closed

Poojapriya Posts 6 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
Transfer data from one excel worksheet to another automatically - Guide
Digital data transmission - Guide
Selection.autofill destination:=range ✓ - Excel Forum
Download tiktok data after ban - Guide
Excel if range of cells contains specific text ✓ - Excel Forum

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
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 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767 > 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!!

Subscribe To Our Newsletter!