Forum Discussion
Link data from another sheet and be able to sort it
I need to link data from 3 separate worksheets to one, I have used the formula =Sheetname!A1:A10 (example) But when I try and sort this information, I get a pop up saying "You can't change part of an...
If you have Microsoft 365 or Office 2021, you can use
=SORT(Sheetname!A1:A10)
If you have an older version, use the formula
=Sheetname!A1
and fill down.
You will then be able to sort.
Problem is, i need to get information from 3 separate sheets into one, and they all need to be sorted from A-Z. So is there another way to maybe link the information that can also be sorted? I haven't been able to find this out anywhere.
