Solved

Copy and Paste Data

Posted on 2011-02-28
14
166 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 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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 500 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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

622 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