Forum Discussion
Excel Macro
I am trying to move values from one sheet to another using a macro, it works when I want to move the whole row as it is but I need to rearrange it a bit before I copy it to the next sheet, I have tr...
Thanks for the reply,
the issue i am having is i have a row with columns from A-F i want to copy A-B and paste to A-B and copy
E-F and paste to C-D and copy C-D and paste to E-F if that make sense.
=CHOOSECOLS(A1:F10,1,2,5,6,3,4)
Does this formula return the intended result? For illustration the dataset and the result is in the same sheet. After the result is populated you can copy the result and paste only the values in order to remove the formula. In my opinion this is easier than a macro however the CHOOSECOLS function is only available in Office 365 and Excel for the web.