Stop Inserting Entire Row, Only Insert Range

This is a very simply problem that I do not know how to fix.

Right now, the code below is inserting an entire row when it pastes the values in I only want the values to be inserted in Range (A:AJ).

The code seems to work great, that is the only problem. Please help.

I gratefully appreciated it.

Please Login or Register  to view this content.

At a glance (untested), try

Please Login or Register  to view this content.

Shg,

Thanks that worked.

Another problem was caused by the new change to the code.
It is copying over the first copy of values.

It copy the values from "Products1" and once that is compled, it then copies the values from "Product2" over the "Product1" values.

Any ideas as to why?

Also, is it possible to have the cells copy and insert starting from columns C instead of column A

No idea without seeing the workbook, no.

Here is the workbook.