I am trying to sort a row of data (left to right) containing names some of which are repeated numerous times in the row. The idea is to move just a single name to the leftmost part of the row including all the cells below. This appears to be quite easy using the sort options and custom sort.

Is it possible to leave the worksheet (Master) intact and copy the sorted data to a new worksheet (Temp) temporarily for review?

I would like to sort (or search) for a specific name in the row and have it appear at the left of the temporary worksheet leaving the Master worksheet intact.

Thanks
Mick