N
NicoleS
*Using Office 2007*
I am using the sort function to organize a list by date and anniversary
year. That works well.
Then I insert blank lines (for readability) between groups of dates
according to weeks on the calendar. No problem.
Next, I want to sort the names alphabetically within the anniversary year
and week. Each time it asks if I want to expand the selection. I say yes so
that all of the data (name, anniv. year, anniv. date, job title, job
location) stays together for each entry. Sometimes this works. Sometimes it
doesn't.
When it works, just the names of associates celebrating 10 year
anniversaries for week 3 are alphabetized (for example), then I alphabetize
the names of associates celebrating 20 year anniversaries).
When it doesn't work, excel disregards the blank lines that I placed and
alphabetizes my whole list - no longer separated by weeks of the month. (it
clumps them all together.)
i hope this makes sense. How can I get it expand the sort to JUST the
section that was highlighted?
I am using the sort function to organize a list by date and anniversary
year. That works well.
Then I insert blank lines (for readability) between groups of dates
according to weeks on the calendar. No problem.
Next, I want to sort the names alphabetically within the anniversary year
and week. Each time it asks if I want to expand the selection. I say yes so
that all of the data (name, anniv. year, anniv. date, job title, job
location) stays together for each entry. Sometimes this works. Sometimes it
doesn't.
When it works, just the names of associates celebrating 10 year
anniversaries for week 3 are alphabetized (for example), then I alphabetize
the names of associates celebrating 20 year anniversaries).
When it doesn't work, excel disregards the blank lines that I placed and
alphabetizes my whole list - no longer separated by weeks of the month. (it
clumps them all together.)
i hope this makes sense. How can I get it expand the sort to JUST the
section that was highlighted?