I have two different excel files that are sent to me by vendors. Each
is formated the same with the same columns, just different data. I
need to merge the two together so that the second file adds to the
first. I cannot seem to find a way to do this. I would have thought a
simple copy and paste would have worked, but that does not seem to be
the case.

Can anyone provide a solution?

Thanks.

Rob