I have an Excel report which retrieves data from another database when refreshed. The contents of cell C1 is basically the same as another cell (literally "=S3"; column S is hidden from view). This is a unique identifier and will be unique every time the spreadsheet is refreshed.

All the data starts from row 3 onwards. What I'd like to happen is once I've refreshed and C1 changes, I'd like the data to automatically be sorted by column F (and of course all the adjacent data together). The data range to be sorted is from columns A-T, and the rows are variable. Sometimes it's just one row (row 3), sometimes it could be up to a hundred or more. Alternatively, if checking to see if C1 has changed is tricky because of the whole "=S3" thing, I suppose checking if S3 changes would be fine too (I just wasn't sure if having column S hidden would cause any trouble or not?).

Thanks.