Find data and copy dynamic range [Solved/Closed]

Question

Find data and copy dynamic range [Solved/Closed]

Report

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 - How-To - Excel
Dynamic range and named ranges ✓ - Forum - Excel
Dynamic Range in excel using vb6 ✓ - Forum - Programming
Excel vba autofill dynamic range ✓ - Forum - Excel

1 reply

Ask a question

rizvisa1 · Accepted Answer · 2015-12-15T15:34:45-0500

Answer 1 / 1

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

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

Report

Poojapriya
Dec 15, 2015 at 11:28 PM

Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell

Report

rizvisa1

Posts: 4476
Registration date: Thursday January 28, 2010
Status: Contributor
Last seen: August 2, 2020

767 > Poojapriya
Dec 16, 2015 at 03:43 AM

see this
https://ccm.net/forum/affich-861811-resize-the-range#p862181

Report

Poojapriya
Dec 16, 2015 at 04:00 AM

ok. thank you!!

Find data and copy dynamic range [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!