Macro to search same digit in J2

[JohnGreen2]

Hi

Need some help with a macro to do the following -I have 2 sheets namely sheet 1 and sheet 2.
On sheet 1 J2 -O2 have variable data as it changes the whole time.I need a macro that will look at J2's value in the example its a 7 then go down in the column until it find the same value in the example 7 then go 1 line up and copy the range to sheet 2 J2 -as per example.Please note J2-O2 is variable data and changes constantly but J2 is the search value that must be searched going down -find the value then go one up and copy that data to sheet2

Your help will be appreciated and rep given for assistance.

[nigelog]

no sample attached

[JohnGreen2]

no sample attached

Attached sorry

[Fluff13]

How about

Please Login or Register  to view this content.

[JohnGreen2]

How about

Please Login or Register  to view this content.

You aced it working perfectly thank you very much for this macro -rep given !!!!!!!!

[JohnGreen2]

Solved by Fluff13 thanks Fluff13

[Fluff13]

You're welcome & thanks for the feedback