<div>
No problem, I have found a workaround. &nbsp;Thanks.
</div>


No problem, I have found a workaround.  Thanks.

<div>
<div class="content wysiwyg-content">
I am trying to figure out how to re-order a series of rows - about 34 in total. &nbsp;I have a series of randomised questions which each has an answer 1-5. &nbsp;I am then planning to import the answers into a column, probably using a macro, but initially probably just cut and paste.<br />
But I need to present the data in a different order (the original order of the questions before they were randomised. &nbsp;<br />
<br />
Is there a quicker way to re-order the data other than just having to manually input formulas in a column like <br />
=A5, <br />
=A15<br />
=A20<br />
=A28<br />
etc?
</div>
</div>


I am trying to figure out how to re-order a series of rows - about 34 in total.  I have a series of randomised questions which each has an answer 1-5.  I am then planning to import the answers into a column, probably using a macro, but initially probably just cut and paste.
But I need to present the data in a different order (the original order of the questions before they were randomised.  

Is there a quicker way to re-order the data other than just having to manually input formulas in a column like 
=A5, 
=A15
=A20
=A28
etc?

Re-order columns of data in Excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.