Previous Topic Next Topic

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!
Related:

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

Sir in dynamic duo point is not increasing why
Aryan -
dwebb -

Sir in dynamic duo point is not increasing why

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

I have been using my mint mobile data for the last one year. Now I am facing some issues with my internet. Please help me to resolve my issue.

2 responses
Unlock safe folder without losing any data
Mintu -
HelpiOS -

Hello, How to unlock my system safe folder without losing any data in Vivo Y100 

1 response
Hosted app data will not clear
Woody_3336 -
woody_3336 -

In google chrome, advanced settings, clear browsing history, my Hosted App Data will not clear. There are over 2,000 apps in there, most are old and not used or needed. I have discovered that most of these old apps have come from shortcuts I created to have a temporary references, and then deleted. I have deleted the majority of these apps individually, but they came back on the next startup. I use avg tuneup to keep my computer clean, and now I regularly clean the browser. It works fine except for Hosted App Data. Can someone help to clean Hosted App Data, beyond browser cleaning.

7 responses
Copy range data in a column to new column.
anthonyishere -
anthonyishere -

Need help here please !!!

Data available : A range of data in a column. Some of the cells are blank.

My requirement : Is there any formula wherein I can copy data from the range in the column to another column in another sheet. I need to copy only filled cells. I also need to have a command which will automatically copy data by the click of one button maybe!! I tried a macro but it doesn't work.

6 responses