How do I sort data in multiple columns by date in one column?

S

sammie

My spreadsheet has 8 columns: vendor name, invoice date, invoice number
description of rented equipment, rental period-2 columns-"from" & "to",
invoice amount and cumulative invoice amount. I want to sort the data by the
invoice date in ascending order (from earliest date to latest date). Neither
my Excel "Help" books or "HELP" in the toolbar have helped. Please help.
Thank You and Happy New Year.
 
G

Gord Dibben

Pre-select all 8 columns then Data>Sort

Sort on the Invoice Date column in ascending order.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table setup 2
How do I add a range by date over 90 days older than today 4
Find partial match from column A,B and fill partial match in C? 4
sort multiple columns 5
Importing Excel when one or more cells contain multiple data 2
How to sort entire spreadsheet by one column sort 5
How do I change the record source of a list box. 2
Code for auto filling in Excel based on number of months, & start date 1

Top