Previous Topic Next Topic

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!

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
4
Poojapriya
Dec 15, 2015 at 11:28 PM
Thanks rizvisa1!.currentregion refer from a3. but I want to copy from a3's adjacent cell
0
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
0
Poojapriya
Dec 16, 2015 at 04:00 AM
ok. thank you!!
0

Similar discussions

AMD data change update new data to DMI
Luis -
dwebb -

1 response
Unlock safe folder without losing any data
Mintu -
HelpiOS -

1 response
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

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

7 responses
Excel Macro - Set and autofill a range?
KT -
excel987 -

28 responses