My company prints a report out that has a P/N column, quantity column, and ship date column. We add a column called comments and send an identical report off to 3 different people to fill in the status on the parts that belong in their department. We get 3 reports back and manually transfer the data from the 3 reports to one report. All 3 report have the same line items. However, if a line item does not pertain to that department, the comments field is left blank. I am not looking to sum anything, just move the reply from each line item to one single report. Is there a quicker way in excel to merge these reports? I am not sure if excel is smart enough to understand to grab only the comment from the one spreadsheet that contains the answer... becasue the other two spreadsheet's comment in column 4 will be left blank. Will excell just overwrite with the whatever the final spreadsheet has on it? See attached, 3 tabs, same info except comment column. I hope I made sense.