asked on
How to lock rows during a sort
I have a spreadsheet with data in several colums and down a number of rows.
Each record comprises data horizontally across the row.
I need to be able to sort this data by eg. date and have all the row data locked together so that when a sort takes place, all data in the row moves together during the sort.
I have tried several ways of attempting to achieve this... but none have worked.
I thought this would be a fairly simple process!!
Any advise on how to do this would be much appreciated.
Each record comprises data horizontally across the row.
I need to be able to sort this data by eg. date and have all the row data locked together so that when a sort takes place, all data in the row moves together during the sort.
I have tried several ways of attempting to achieve this... but none have worked.
I thought this would be a fairly simple process!!
Any advise on how to do this would be much appreciated.
Spreadsheets
Last Comment
rapserv
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
the tutorial was exactly what I wanted ... to the point and easy to understand. Thanks again ....David (rapserv)