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

Options

Best Answer

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Answers

  • Paul McGuinness
    Paul McGuinness ✭✭✭✭✭✭
    Answer ✓
    Options

    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
    Options

    Thank you. It worked! I was overthinking it.