so im thinking if theres a way to connect 2 spreadsheets. 1 for viewing lets name it SpreadsheerA and another one for editing SpreadsheetB. The reason for this is im trying to make SpreadsheetA with only 5 columns for example and SpreadsheetB with 7 columns. I'm planning to sort the table based on the last 2 columns but i want it hidden hence the SpreadsheetA having 5visible+2hidden columns and it being an uneditable spreadsheet.
Yes, in Sheet 1 put =Sheet2!A1 in cell A1, =Sheet2!A2 in cell A2 etc.
Now hide the columns you want to hide and protect Sheet 1.
Sheet 1 will now mirror sheet 2, but will be uneditable.
(If you want to do this across different files, this is also possible using the same technique.)