Home |
Search |
Today's Posts |
#1
|
|||
|
|||
another interesting thing...
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interesting Counting Question...HELP | Excel Discussion (Misc queries) | |||
How do I get one cell to type the same thing as another cell? | Excel Discussion (Misc queries) | |||
Is there such a thing... | Excel Discussion (Misc queries) | |||
Lengthy and weird, but interesting | Excel Worksheet Functions | |||
Strange thing happened with TOC | Excel Discussion (Misc queries) |