Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackmac
 
Posts: n/a
Default Sort data into order of product

Hi there,

I've got a list of products for my company but it is listed in product
group, the products for that group coming underneath.. like this:

MT-AUDIO-MOUNTS:
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white

MT-SPEAKER-WALL:
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white

MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001

MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount

I want if possible to create a new list which will show the product group
with the products underneath..like this

MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white

MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white

Anybody got any ideas?

TIA...Jack


  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default Sort data into order of product

Again. Post in ONE group only

--
Don Guillett
SalesAid Software

"Jackmac" wrote in message
...
Hi there,

I've got a list of products for my company but it is listed in product
group, the products for that group coming underneath.. like this:

MT-AUDIO-MOUNTS:
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white

MT-SPEAKER-WALL:
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white

MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001

MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount

I want if possible to create a new list which will show the product group
with the products underneath..like this

MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white

MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white

Anybody got any ideas?

TIA...Jack



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jackmac
 
Posts: n/a
Default Sort data into order of product

Please see MY reply in ANOTHER newsgroup Don.

"Don Guillett" wrote in message
...
Again. Post in ONE group only

--
Don Guillett
SalesAid Software

"Jackmac" wrote in message
...
Hi there,

I've got a list of products for my company but it is listed in product
group, the products for that group coming underneath.. like this:

MT-AUDIO-MOUNTS:
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white

MT-SPEAKER-WALL:
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white

MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001

MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount

I want if possible to create a new list which will show the product group
with the products underneath..like this

MT-AUDIO-MOUNTS:
B-Tech BT325 disco/PA speaker mount in black
B-Tech BT325K fixing kit for BT325
B-Tech BT325X adaptor for external mount
Vogels VRS045 VCR/DVD support in black
Vogels VRS045 VCR/DVD support in silver
Vogels VRS045 VCR/DVD support in white

MT-SPEAKER-WALL:
Kef 3 x wall brackets for KHT1001
Vogels VLB100 tilting speaker wall mount in black
Vogels VLB1015 center speaker wall mount in silver
Vogels VLB1025 speaker wall mount in silver
Vogels VLB200 speaker wall mount in black
Vogels VLB50 speaker wall mount in black
Vogels VLB50 speaker wall mount in silver
Vogels VLB50 speaker wall mount in white

Anybody got any ideas?

TIA...Jack





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge and sort pages of data RD Wirr Excel Worksheet Functions 2 December 21st 05 06:38 AM
Sort order : Excel vs imported data John Excel Discussion (Misc queries) 0 December 9th 05 01:40 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Using a macro to sort your data in alphabetical order? Carrie Excel Discussion (Misc queries) 1 April 14th 05 03:07 PM
Daily Macro to Download Data, Order and paste in order Iarla Excel Worksheet Functions 1 November 17th 04 01:59 PM


All times are GMT +1. The time now is 03:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"