Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 169
  • Last Modified:

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
0
Cartillo
Asked:
Cartillo
  • 7
  • 6
1 Solution
 
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
 
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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:
Sorry my mistake. Pls chk this version and let me know.
Rgds/gowflow
SearchData2.xls
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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 7
  • 6
Tackle projects and never again get stuck behind a technical roadblock.
Join Now