I have several columns that I want to sort on a separate worksheet. I input
the info on sheet 1 and would like for specific columns only to appear on
sheet 2.
For example:
Column A Column B Column C Column D
(area) (check/recheck) (hours) (problems)
South CH 1 0
West RECH 1 1
South CH 1 1
West CH 1 1
West RECH 2 0

On Sheet 2 I would like to sort The area and only have Column A and the
corresponding Column D appear. That way whenever I input the info on sheet 1
it automatically sorts the info and puts it into order by West, South etc. on
sheet 2.
How do I do this?