I have two worksheets. Both worksheets have data in column A, B, C, D, E, F,
and G. Column B has a list of with text and numbers(this is in both
worksheets). There are multiple duplicates in each worksheet. I need to
combine the two worksheets into one worksheet with no duplicates.

I also need to pull the data in the other columns over to the new worksheet.

I really need help with this. The boss is expecting a more efficient way of
doing this report.