Reading, Comparing and Writting
 

I am trying to find out if is possible to take input from one column of a spreadsheet one-by-one, compare the content of cells with the contents of cells in a column of another spreadsheet and then if it matches, it dumps the content of rows in which it matches to another empty spreadsheet.

Ex.
Company spreadsheet A Report spreadsheet B Report Spreadsheet
A1 Silking Brothers A1 Joyce B1 Full C1 Proposal A1 Joyce B1 Full C1 Implement
A2 Joyce A2 Toshiba B2 Partial C2 Implementation A2 Avaya B2 Partial C2 Opportunit
A3 Toshiba
A4 Avaya

End Spreadshee
Output Spreadsheet
A1 Joyce B1 Full C1 Proposa
A2 Joyce B1 Full C1 Implemen
A3 Toshiba B3 Partial C3 Implementatio
A4 Avaya B4 Partial C4 Opportunit


Thank
Krishn