Copy dropdown selection to next row, different column

So i have a ColumnA and ColumnB that are both dropdowns (set to allow editing). Is there a formula to copy ColumnB (Row1) selection to ColumnA (Row2)? I would like to have this go all the way down the column, so Column B selection is always ColumnA (on the next row).


  • Jason Albrecht
    Jason Albrecht ✭✭✭✭✭✭

    Hi @Jhoaas

    In Column A (Row 2) I would put the formula 'equals Column B (Row 1)' and enter.

    Clicking back onto Column A (Row 2) I would then press Shift + Ctrl + Down Arrow.

    With the balance of Column A highlighted, I would then press Ctrl + D to copy down the formula.

    Hope this helps. Let us know how you go.

    Hope this helps and that you have a great day,

    Jason Albrecht MBA, MBus(AppFin), DipFinMgt

    LinkedIn profile - Open to work