Solved

Copy and Paste Data

Posted on 2011-02-28
14
165 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 30

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
Technology Partners: 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 30

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 30

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 30

Accepted Solution

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

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 30

Expert Comment

by:gowflow
ID: 35008797
Your welcome ! tks for the grade !
:)
gowflow
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Excel not storing numeric string correctly 5 42
sort time order 10 45
Custom fill series 12 38
Looping through files in a folder VBA 3 11
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
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…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

734 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