A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sort data into order of product



 
 
Thread Tools Display Modes
  #1  
Old February 21st, 2006, 03:45 PM posted to microsoft.public.excel.misc
external usenet poster
 
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  
Old February 21st, 2006, 03:55 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Sort data into order of product

PLEASE only post in ONE group. See answers in first post.

--
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  
Old February 21st, 2006, 04:00 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Sort data into order of product

You have one reply at your other post in .excel.

Jackmac wrote:

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


--

Dave Peterson
  #4  
Old February 21st, 2006, 04:09 PM posted to microsoft.public.excel.misc
external usenet poster
 
Posts: n/a
Default Sort data into order of product

Unfortunately as there are approximately 175 different product groups in our
stock list, your solution would take too long to implement so I decided to
ask in another independent newsgroup.

"Don Guillett" wrote in message
...
PLEASE only post in ONE group. See answers in first post.

--
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





 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort data into order of product Jackmac Worksheet Functions 2 February 21st, 2006 04:08 PM
Unable to have multiple queries feeding a single report PZ Straube Setting Up & Running Reports 15 June 15th, 2005 08:16 AM
SQL view of messed up action queries Kendra Running & Setting Up Queries 2 August 31st, 2004 09:53 PM
can't reinstall office xp pro after deleting from windows xp syste dana Setup, Installing & Configuration 1 August 5th, 2004 06:32 PM
How to create graphs in a monthly report where the base data can change John Clarke Charts and Charting 3 June 25th, 2004 02:22 AM


All times are GMT +1. The time now is 02:26 PM.


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