help combining excel sheets

[CSdjohnson]

I have two excel spreadsheets and there are three columns that I need to have match in both sheets.

I have columns for sec salesman, sec custname, sec custloc for an invoice number. some of the rows are filled in and some are blank.

on a second sheet I have the same thing, but the information missing from the rows on the first sheet is filled in on the rows on the second sheet, and the information filled in on the rows on the frist is missing from the second.

I need to beable to have the missing information on the first sheet filled in by the information on the second.

I hope this makes some sense. Any help would be great.

thanks,
Dan

 

[jfhewitt]

Copy cells from one sheet to the other, using Paste Special, Link.