Grouping cells
 

I have a particular group of cells within a sheet which I need to group
together and sort. However I need to keep the rows of information locked
together so when you sort the data it doesnt get all mixed up. Is there a
way to do this? If so, how?

If it is possible to do the above is it possible to have it to automatically
sort the information as your adding it into cells?

Thank you for your time.

if i understand you correctly you must select the whole range of data you
want sorted.Ie if you are sorting a list of names,addresses phone numbers ,by
say a column of joining dates you must select al the asociated data too ,as
well as the column(s) you want to actually sort by
--
paul
remove nospam for email addy!



"Michael Blogg" wrote:

I have a particular group of cells within a sheet which I need to group
together and sort. However I need to keep the rows of information locked
together so when you sort the data it doesnt get all mixed up. Is there a
way to do this? If so, how?

If it is possible to do the above is it possible to have it to automatically
sort the information as your adding it into cells?

Thank you for your time.

I understand what you are saying Paul, however is there a way that a "sort"
function can be set automatically for a group of particular cells?

For example;

I have set 6 columns on a spread sheet "Column B - Column G"

Say I have 150 rows of information starting at "Row 19 - 169"

However when I do sort all the data it jumbles all the information up. I
need to effectively lock the rows so the information doesn't get messed up.
So all the information in a row is tied to the first column and stays in
that order.

"paul" wrote in message
...
if i understand you correctly you must select the whole range of data you
want sorted.Ie if you are sorting a list of names,addresses phone numbers
,by
say a column of joining dates you must select al the asociated data too
,as
well as the column(s) you want to actually sort by
--
paul
remove nospam for email addy!



"Michael Blogg" wrote:

I have a particular group of cells within a sheet which I need to group
together and sort. However I need to keep the rows of information locked
together so when you sort the data it doesnt get all mixed up. Is there a
way to do this? If so, how?

If it is possible to do the above is it possible to have it to
automatically
sort the information as your adding it into cells?

Thank you for your time.