PDA

View Full Version : Excel - Sort data after report refresh and certain cell changes?



Smeghead
03-30-2015, 03:28 AM
I have a report where press refresh and I am prompted to enter a unique 8 digit number, and then data is returned from row 3 downwards. The same unique number is returned in column S.

I'd like to be able to sort the data A-Z by column F (and of course all the data in the adjacent cells together with their rightful row, if that makes sense) either after each refresh, or after the contents of cell S3 changes (the latter method may be a bit more complicated because the number is never directly typed into the spreadsheet itself, it's only returned from the refresh).

Thanks.