Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Trying to find Matches and Give a Result | Excel Worksheet Functions | |||
item # in one sheet want to pull data that matches from other tab | Excel Worksheet Functions | |||
Using the If or lookup statement to find matches | Excel Worksheet Functions | |||
how to find all matches in an array | Excel Discussion (Misc queries) | |||
If Info. from one Sheet matches, send it to another sheet | Excel Discussion (Misc queries) |