Re: Alphabetize sets of rows within a WB
- From: Toney <Toney@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 18 Sep 2009 07:19:02 -0700
Ron
I assumed your data was in the format as above.That was my fault.
The macro worked great except I didn't give enough detail. Each record
actually consists of a file name, date, time and size except for the
directories which has only the name...
K:\PMC\BECKY\
File D.doc Date Time Size
File A.doc Date Time Size
File C.doc Date Time Size
File B.doc Date Time Size
K:\PMC\DAN\
File E.doc Date Time Size
So the final result would be...
K:\PMC\BECKY\
File A.doc Date Time Size
File B.doc Date Time Size
File C.doc Date Time Size
File D.doc Date Time Size
K:\PMC\DAN\
File E.doc Date Time Size
As I said your macro worked great except it re-ordered the just the file
names and left the date, time and size columns alone. Sorry for the confusion
(I've learned my lesson...give ALL the info in the first post. It saves time
later)
Thanks
Toney
.
- Follow-Ups:
- Re: Alphabetize sets of rows within a WB
- From: Ron Rosenfeld
- Re: Alphabetize sets of rows within a WB
- References:
- Alphabetize sets of rows within a WB
- From: Toney
- Re: Alphabetize sets of rows within a WB
- From: Ron Rosenfeld
- Alphabetize sets of rows within a WB
- Prev by Date: Re: Numbering pages, starting at a particular number
- Next by Date: Re: My hyperlinks do not open ...
- Previous by thread: Re: Alphabetize sets of rows within a WB
- Next by thread: Re: Alphabetize sets of rows within a WB
- Index(es):
Relevant Pages
|
