I need to create a macro that will compare two spreadsheets (two separate
documents); looking at two columns for matching numbers. When the number is
identical, the macro will copy the cells from that row in the first document
to the end of the row of matching data in the 2nd spreadsheet, then continue
through the remainder of the file.

Example: File 1 has column C = File Number. File 2 has column E = File
Number. Macro reads File 1 first file number, looks at File 2 and locates a
row with that information. It then grabs the cells from the row in File 1 and
pastes them into empty cells after the data in File 2. It goes through that
for every row in File 1 and reports back that it has completed xxx rows.

Any and all assistance will be greatly appreciated.