Copy Rows to Another Sheet not working - Column has the same name as a system column on the source

Sandra Barlao

Help please.

I am trying to set up an automation that copies data from my Main Purchase Request Sheet to my Line Items Sheet. However, I keep encountering an error message stating, "Rows can't be added to the destination worksheet because a column has the same name as a system column on the source sheet."

Here are the specifics of my sheets:

Main Purchase Request Sheet Columns:

• PR#
• Status
• Requestor Name
• Request Category
• Other Request
• Request Reason
• Department
• Delivery Date
• Delivery Address

Line Items Sheet Columns:

• PR#
• Item #
• PR Line Item ID
• Item Name
• QTy
• Uom
• Price
• Total Price
• Supplier Details
• Status

kowal

Hey Sandra,

could you tell me what is the name of the system column in the source and destination sheet? The system column is the one with bold name where the hierarchy is kept.