Copy and Paste Data

Hi Experts,

I would like to request Experts help create a macro for search data from Validation2 sheet (Data from Column “Number” or “Type”) and the search result showed at SearchData sheet (I have manually copied few sample data for Experts to get better view). The search query is entered at cell E2 “searchData” sheet. Hope Experts will help me to create this feature. Attached the workbook for Experts perusal.



SearchData.xls
CartilloAsked:
Who is Participating?
 
gowflowConnect With a Mentor Commented:
Sorry my mistake. Pls chk this version and let me know.
Rgds/gowflow
SearchData2.xls
0
 
TvMptCommented:
0
 
CartilloAuthor Commented:
Hi,

I’m intent to combine other function as well in this request function. Hope Experts will consider to create a macro for copy and paste data at Validation sheet based on entered value at cell E2.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
gowflowCommented:
Hi Cartillo,

Pls chk if this is what you want. Simply type in what you need to search in E2 and chk the results.

Rgds/gowflow
SearchData.xls
0
 
CartilloAuthor Commented:
Hi gowflow,

Thanks for the help. Is that any rules apply when we search the data. I noticed the data not displayed properly after the search query has exceeded 25,000 rows. Hope you can help me make it flexible on the rows search from Column A:BW (all cells until the end).
0
 
gowflowCommented:
No rule whatsoever ! Again you deal with huge data. Is the search ok with fewer rows ?
Did you happen to try the solution proposed on previous question (Matched/Missed) with the progress bar ?
gowflow
0
 
CartilloAuthor Commented:
Hi Gowflow,

The data search perfectly with fewer rows but intermittent malfunction with huge data. Is that way for us to tackle this. Most likely I need to crosschecked even huge data, could reach 2 millions.

Match/Missed solution works fine in my Laptop but not in my other PC. I currently tackling that issue. Something wrong with my PC OS I guess. Will update you once I fixed the OS. Sorry for the delay.    
0
 
gowflowCommented:
ok as far as this question is concerned pls try this new version and let me know the results. The faster we can exchange the better we can find solution.

By the way for Missed.Matched how long it took to complete your zillion rows (some 40000 if I remember well ?)
Rgds/gowflow
SearchData2.xls
0
 
CartilloAuthor Commented:
Hi,

Have tested, the search is now works until the end, but the result not showing the right outcome. The message Box gives the right total number but the cells showed totally different data (not as per search). Please assist.  
0
 
CartilloAuthor Commented:
Hi,

Overlooked your second Q,sorry. It's almost 20minutes to accomplished 1,567,345 data. At least I got the result.  
0
 
gowflowCommented:
wow 1567345 in 20min !!! I think its great don't you ?
gowflow
0
 
CartilloAuthor Commented:
Hi Gowflow,

You're right. It's great!!
0
 
CartilloAuthor Commented:
Hi,

Thanks a lot for the help.
0
 
gowflowCommented:
Your welcome ! tks for the grade !
:)
gowflow
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.