A little hard to explain... but..
I have a sheet.
rows 10-20 contain data spread across multiple columns. There's even a picture.
Rows 21-30 has a new block of data
etc
etc
the rows and columns of data are 1 object.
I then want to sort the sheet based on values in 'sort' column. and when I do it sorts each block based on the sort column. So if the sort data was 1,2,3,4,5,6, I could sort the data and each object would sort by the value in it's sort column.
I don't necessarily need the sort column I just thought it might make it easier?
so how can I lock/group/link a bunch of rows/column into 1 sortable object?
Bookmarks