On Monday, September 24, 2012 8:49:33 PM UTC-5, John Tonitto wrote:
I have a master list that i need to separate out into sevral lists based

on there values (see example)



Additionally, I would like that the redistributed lists contain the

values and discriptions from the master list and be listed on consective

lines.



List A

Kitchen 5000

Toilet 300

Taps 100

Lights 400

Carpets 2300

Tiles 1600

Doors 900





List b List c List d

< $300 $300 - $1200 Above $1200

Toilet 300 Lights 400 Kitchen 5000

Taps 100 Doors 900 Carpets 2300

Tiles 1600



Cheers

John









--

John Tonitto

Unless you have a REALLY good reason, do NOT do that. Simply use datafilterautofiter instead