sorting dates in Excel 97

Running a worksheet that lists all medical expenses and am not able to
always insert date, expense, who to, in correct sequence. Some postings just
come in on time. Is there a sort formula that will allow me to sort these
entries in sequence? Will the sorting move up the entire row that lists
date, amount, payable to, etc. also? Thank you, Steve T.

I wouldn't use any formulas for this.

I'd select the range (all the columns in that range, plus the last row of
headers, plus all the data) and do Data|Sort

If you include all the columns that should move with the sort, you'll be fine.

But save your file first, then double check it after. If it didn't work ok,
just close without saving and reopen and try again.

Steve T wrote:
>
> Running a worksheet that lists all medical expenses and am not able to
> always insert date, expense, who to, in correct sequence. Some postings just
> come in on time. Is there a sort formula that will allow me to sort these
> entries in sequence? Will the sorting move up the entire row that lists
> date, amount, payable to, etc. also? Thank you, Steve T.

--

Dave Peterson

Thanks Dave! Data|Sort worked just fine. Steve T
"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:44D10EBA.6BF08CE0@verizonXSPAM.net...
>I wouldn't use any formulas for this.
>
> I'd select the range (all the columns in that range, plus the last row of
> headers, plus all the data) and do Data|Sort
>
> If you include all the columns that should move with the sort, you'll be
> fine.
>
> But save your file first, then double check it after. If it didn't work
> ok,
> just close without saving and reopen and try again.
>
> Steve T wrote:
>>
>> Running a worksheet that lists all medical expenses and am not able to
>> always insert date, expense, who to, in correct sequence. Some postings
>> just
>> come in on time. Is there a sort formula that will allow me to sort these
>> entries in sequence? Will the sorting move up the entire row that lists
>> date, amount, payable to, etc. also? Thank you, Steve T.
>
> --
>
> Dave Peterson