Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Copy and Paste Data

Posted on 2011-02-28
14
Medium Priority
?
168 Views
Last Modified: 2012-05-11
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
Comment
Question by:Cartillo
  • 7
  • 6
14 Comments
 
LVL 9

Expert Comment

by:TvMpt
ID: 34995666
0
 

Author Comment

by:Cartillo
ID: 34995698
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
 
LVL 31

Expert Comment

by:gowflow
ID: 34996618
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Cartillo
ID: 34997992
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
 
LVL 31

Expert Comment

by:gowflow
ID: 34998026
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
 

Author Comment

by:Cartillo
ID: 34998190
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
 
LVL 31

Expert Comment

by:gowflow
ID: 34998377
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
 

Author Comment

by:Cartillo
ID: 34998534
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
 

Author Comment

by:Cartillo
ID: 34999153
Hi,

Overlooked your second Q,sorry. It's almost 20minutes to accomplished 1,567,345 data. At least I got the result.  
0
 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 34999661
Sorry my mistake. Pls chk this version and let me know.
Rgds/gowflow
SearchData2.xls
0
 
LVL 31

Expert Comment

by:gowflow
ID: 34999684
wow 1567345 in 20min !!! I think its great don't you ?
gowflow
0
 

Author Comment

by:Cartillo
ID: 35008682
Hi Gowflow,

You're right. It's great!!
0
 

Author Closing Comment

by:Cartillo
ID: 35008700
Hi,

Thanks a lot for the help.
0
 
LVL 31

Expert Comment

by:gowflow
ID: 35008797
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question