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
Excel - Selectively Transfer Data to Pre-defined Range - How-To - Excel
Excel data validation list multiple ranges - Guide
Dynamic range and named ranges ✓ - Forum - Excel
Dynamic Range in excel using vb6 ✓ - Forum - Programming
Excel vba autofill dynamic range ✓ - Forum - Excel

1 reply

Answer 1 / 1

rizvisa1

Posts: 4479
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: May 5, 2022

769
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

769 > 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!