Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Sorting Help

Ok, Here is an example of what I am trying to do. All three columns of
information go with each client, using 3 seperate rows. I also put a border
around each set so that it looks better and helps me to see more clearly each
set of rows as seperate information regarding each client. Now, when I go to
sort it in alphabetical order, it moves the client names up into my blank
rows under each client name and will not see the blank cells as being part of
the other group. Also, my borders stay with the cells instead of moving with
the client information that I put it around in the first place. This is
really a problem for me because my client list changes and grows everyday.
Every time I add a client and sort it, my information is screwed up again and
I have to go back and redo my borders and fix the blank cells, etc.

A B C
________________________
John Doe 1111 RRRR
4444 UUUU
7777 YYYY
________________________
Jane Doe 5555 UUUU
8888 IIII
0000 OOOO
________________________
Sarah Doe 7777 PPPP
5555 BBBB
9999 CCCC
________________________

I hope this explains it well enough for someone to help me. I'm frustrated.

 
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
Sorting Sorting Sorting Skydiver Excel Discussion (Misc queries) 4 June 3rd 06 02:42 PM
Sorting SnobbishJade New Users to Excel 6 April 2nd 06 02:08 AM
Sorting Data in ascending order sharon2006 Excel Discussion (Misc queries) 1 March 14th 06 01:07 AM
sorting non contiguous ranges gsh20 Excel Discussion (Misc queries) 1 September 8th 05 04:50 PM
Advice sought: Multiple column sorting davidm Excel Worksheet Functions 3 July 29th 05 02:06 PM


All times are GMT +1. The time now is 01:16 PM.

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

About Us

"It's about Microsoft Excel"