Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
compare and merge 2 sheets if columns same
Hello, Can someone please tell me how I can take data from 2 differen spreedsheets and if 2 of the columns are the same in each sheet merg data into a new sheet. Example sheet 1 col a col b col c col d name phone address note sheet 2 col a col b name phone if the data is the same for the first 2 colums in both sheets I woul like to have all data from sheet 1 put into a new sheet with just lik data. Thanks, Dan -- danale ----------------------------------------------------------------------- danalee's Profile: http://www.excelforum.com/member.php...fo&userid=1524 View this thread: http://www.excelforum.com/showthread.php?threadid=26872 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to compare two columns on two sheets and copy associated data from one sheet to the other? | Excel Worksheet Functions | |||
Compare and merge | Excel Worksheet Functions | |||
Compare and Merge | Excel Discussion (Misc queries) | |||
compare and merge data | Excel Worksheet Functions | |||
How do I compare two columns on seperate sheets and replace text . | Excel Worksheet Functions |