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.