Copy dropdown selection to next row, different column

Jhoaas

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

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.