I have a worksheet with data sorted by say "Job Number". I re-sort on another criteria say "part number" and save it to a different file. Surely there is a simple way I have missed to view my data sorted different ways on different sheets. I would like to have it where the data is live (i.e.: I edit it on one sheet and it updates them all). What basic have I missed. TIA