Would like for this Macro to place answers on next sheet

[Jack-P-Winner]

I run this search function with this macro and i when it gives me the answers I have to click on the gray box that says NEXT and it will go to the next pattern I am looking for. How is it possible to have it take all the locations it finds and paste them on the next sheet along with 10 rows above and below it?

How it works is I place the numbers vertically I am looking for in this example 2 10 2 in column C:2 through C:4 and then I click on the gray box under GHI:7 - 11

Once this happens another box comes up that says select range. I will then high lite the numbers in C (the 2 10 2) then click okay and it will find all the locations that 2 10 2 are in column C. I have to keep clicking Next to go to the next location and I can not copy and paste what it finds to compare unless I stop the process and start all over again.

Is it possible to change the Macro so it will place the answers to the next sheet with 10 rows above and below it? Or at least so I can stop the process and copy and paste each location it finds without having to do the search all over again

Thanks y'all!!

It is too large to upload and I shortened it as much as I can

https://onedrive.live.com/redir?resid=ABA6DC5F6B4EABEB!924&authkey=!AKB9ks5snepVBz8&ithint=file,xlsm

 

[Jack-P-Winner]

see if this makes better sense what I am trying to do, the last file did not upload correctly


Instructions:

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

This should make better sense LOL, sorry for the confusion and wasted time


https://onedrive.live.com/redir?resid=ABA6DC5F6B4EABEB!928&authkey=!AHWmXiSuTMBUiOA&ithint=file,xlsm

 

[Jack-P-Winner]

I have been playing around with this for the past few days trying to use record a macro and can't seem to get the just of how to make it search for random strings and place them on the next page. I can easily duplicate what is there

Can someone perhaps get me started in the right direction? I do not mind doing all the work but its knowing how that stops me

Thanks you!!

 

[Jack-P-Winner]

I completed this last night!!

yay!!!!!!!