Copying rows to a new sheet. I can't figure out how to fix this.

Wendy Gaines

Paul McGuinness

Hi @Wendy Gaines

To fix this go into both sheets and locate the primary column in each case, the name of the columns will be different across the two sheets.

You need both primary columns in both sheets to be the same name, so you will need to rename the primary column in the source sheet to match the primary column in the destination sheet.

Alternatively if there is no data in the destination sheet and its not tied into any reports or dashboards etc. the easiest fix is to delete the destination sheet and Save a new copy of the source sheet as the columns will align perfectly. You can then delete all the rows from the new destination sheet and row copying should work fine.

Hope that helps

Thanks

Paul

Paul McGuinness

Hi @Wendy Gaines

To fix this go into both sheets and locate the primary column in each case, the name of the columns will be different across the two sheets.

You need both primary columns in both sheets to be the same name, so you will need to rename the primary column in the source sheet to match the primary column in the destination sheet.

Alternatively if there is no data in the destination sheet and its not tied into any reports or dashboards etc. the easiest fix is to delete the destination sheet and Save a new copy of the source sheet as the columns will align perfectly. You can then delete all the rows from the new destination sheet and row copying should work fine.

Hope that helps

Thanks

Paul

Wendy Gaines

Thank you. It worked! I was overthinking it.