Maybe there's an easy way to do this. A lot of my excel work revolves
around data pulled from a live database. I'll have variable length
tables. My current issue has to do with a set of information as below.
(prepare for scrolling).

------------ SNIP ------------
07 Natural Remedies 8842 10-10
07 Renew Life 10253332 10-11-0
07 Renew Life 10253332 10-11-0
07 Renew Life 10253332 10-11-0
07 Renew Life 10253332 10-11-0
07 Renew Life 10253332 10-11-0
07 Renew Life 10253332 10-11-0
07 Renew Life 10253332 10-11-0
07 United 649464
07 United 649464
07 United 649464
07 United 649464
07 United 649464
07 United 649464
07 United 649464
07 United 649464 10-19-05CR
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 Nutraceutical 3220889.1 10-
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 TOL 103943768 10-19-05 CR
07 Select Nutrition 652686 10
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Sami's Bakery 14103 10-18-
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527 10-17-05
07 Now 568527CR 10-17-05
07 Now 568527CR 10-17-05
07 Now 568527CR 10-17-05
07 Natures Way 91045097 10-19
07 Nature's Way 91045114 10-19
07 Nature's Way 91045114 10-19
07 Nature's Way 91045114 10-19
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05
07 United 677582 10-26-05CR
07 United 677582 10-26-05CR
------------ SNIP ------------

What I'd like to do is take this column from sheet 1 and have the data
autofiltered to sheet 2 so it appears as such, removing repetitions:

------------ SNIP ------------
07 Natural Remedies 8842 10-10
07 Nature's Way 91045114 10-19
07 Natures Way 91045097 10-19
07 Now 568527 10-17-05
07 Now 568527CR 10-17-05
07 Nutraceutical 3220889.1 10-
07 Renew Life 10253332 10-11-0
07 Sami's Bakery 14103 10-18-
07 Select Nutrition 652686 10
07 TOL 103943768 10-19-05
07 TOL 103943768 10-19-05 CR
07 United 677582 10-26-05CR
07 United 649464
07 United 649464 10-19-05CR
07 United 677582 10-26-05
------------ SNIP ------------

The trick is, I want to see it happen automatically, and when the first
sheet refreshes, I'd like to have the 2nd sheet automatically refresh
also.

Any information is helpful. Thanks in advance - you folks are always a
great source of information.

O.B.D. Ben/ND