Find Data from one sheet that matches
 

I have a column of values on one sheet(2). This values exist on another
sheet(1) with more data in the row.
What I am looking to do, is if the values exists on sheet(1), I want to copy
all the data in that row to where the value is on sheet(2).
How can i do this with a macro or vba ?
Hope that makes since
Brian

Find Data from one sheet that matches
 

Or maybe even make the value in sheet(2) a hyperlink to the match in Sheet(1)

"Brian Shafer" wrote:

I have a column of values on one sheet(2). This values exist on another
sheet(1) with more data in the row.
What I am looking to do, is if the values exists on sheet(1), I want to copy
all the data in that row to where the value is on sheet(2).
How can i do this with a macro or vba ?
Hope that makes since
Brian