Creating another view of the same data without copy-paste
In Sheet 1 I have columns:
In Sheet 2, I need the same details to appear, but with the records in descending order of Marks.
In future, when more records are added in Sheet 1 or any records are modified or deleted, I want the table in Sheet 2 to be automatically updated.
How can this be done?