Another one for you, if I may? I've got a spreadsheet which pulls data from another workbook. What my boss wants is a few line below the report, to see an extract of the same report, but just 5 lines of it, being the top 5 results of a sort. I know that makes no sense at all, so I've attached an example of how it might look (I've pasted values on it). At the top is the main report - could be anywhere from 20 - 2000 lines - and mornally about 65 columns. this will always be sorted by Column L in this example. Below all of this are two extracts, one showing the highest cover lines, the other showing the lowest. This report is updated weekly, and the extract needs to reflect this. Can you think of any way of doing this? I've tried creating a Macro to do it, which mmics me copying into a new sheet, sorting & copying back, but this just doesn't give me the flexability I need. Is this even possable? Thanks!