What do you mean by "sort"? Do you want Sheet 2 to look like:

Column A Column B
(area) (problems)
South 0
South 1
West 1
West 1
West 0


or
Column A Column B
(area) (problems)

South 1
West 2

Or what?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Blissfully Ignorant" wrote
in message ...
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?