Microsoft Office Forums Want to change Macro to copy and paste data to new sheet

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2014, 09:53 PM
Vortex69 Vortex69 is offline Want to change Macro to copy and paste data to new sheet Windows 7 64bit Want to change Macro to copy and paste data to new sheet Office 2010 64bit
Novice
Want to change Macro to copy and paste data to new sheet
 
Join Date: Dec 2014
Posts: 1
Vortex69 is on a distinguished road
Default Want to change Macro to copy and paste data to new sheet

I have a Macro that searches for numbers vertically.



When you open the file you will see under column C the numbers 2 10 2 in rows C:2 C:3 C:4. I am looking for all the number sequences down column C that have the 2 10 2 in them

Click on the button labeled "Find Patterns"
That brings up a box that says select range(s) you will high lite C:2 to E:2 and drag down to C:4 E:r and then press k"

This will begin the search. When it finds the answers it will show you a location that the next set of numbers ( 2 10 2) are in $C$17:$E$22
click on "ok" this brings you to that location

Now, for what I want I need help with. I want to be able for the Macro to copy and paste all the locations it finds and place them on the next sheet with 10 rows above and 10 rows below (info from B:J)

If this can not be done easily then I would like the ability to pause the search and copy the location to another sheet manually and then start where it left off. Presently every-time I go to copy and paste, I have to stop it and start all over again. Ideal would be to copy and paste to the next sheet which will save an enormous amount of time

Here is the file

http://www.mediafire.com/download/u5...er_Search.xlsm
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to copy all data from a website to excel sheet? Plz plz plz plz plz help...urgent Sam123 Excel 0 07-19-2014 02:12 AM
How to copy data automatically to particular sheet? nicholes Excel Programming 13 03-12-2014 01:05 AM
How to Copy data from Outlook mail and Paste it in a Excel sheet? padhu1989 Outlook 0 09-11-2012 04:07 AM
Losing Text box data when copy and paste Spay Excel 0 03-15-2011 07:18 AM
copy cell from sheet 2 to sheet 3 macro slipperyjim Excel Programming 1 02-18-2010 01:31 AM


All times are GMT -7. The time now is 06:23 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft