Sort referenced cells by cell value, not content

[dajare]

I have some textual data in a Calc spreadsheet in Sheet1. It is referenced on another sheet.

Having re-ordered the data on Sheet1, the sort order on the other sheet now looks something like this:

=$Sheet1.A2
=$Sheet1.A3
=$Sheet1.A6
=$Sheet1.A1
=$Sheet1.A5
=$Sheet1.A4

When I try to use the Data > Sort options, it will only offer me an alphabetical sort of the content, NOT a sort on the cell numbers (A1, A2, A3, etc.).

Question: Is there a way to make Calc sort these cells on the value of the cell number, rather than an alpha sort of the referenced content? I live in hope!

I have looked at these Q&As without working out my question, so perhaps I’m missing something:

• Sorting a range that is referenced elsewhere
• How to use cell value as a row number in referencing?

[LKeithJordan]

Let’s assume you currently have only one column on Sheet 2. My suggestion would be to add a column to Sheet 2 that allows you to specify the desired order for the cells in question – then perform the sort for both columns on Sheet 2 based on the “Order” column.

Hope this helps.

Please click the check mark next to the response you believe best answers your question.