gentlemen, thank you for your suggestions. i went with the info from max and
it works like a charm. thank you all again.

"Max" wrote:

Try this on a copy of your data sheet. Select the entire table carefully
(this ensures everything will move together), then just do a Data Sort by
(date col) Ascending (say) OK. And if the dates do not respond to the
sort, then they aren't real dates (real dates are numbers). You can try
converting the "dates" all at one go via Data Text to Cols. Select just the
dates col, then click Data Text to Cols. Click Next Next. In step 3 of
the wizard, check "Date" under Col data format, then choose the appropriate
selection (eg: DMY) from the droplist. Click Finish.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,000 Files:362 Subscribers:62
xdemechanik
---
"wynb" wrote:
..i have a spreadsheet with multiple columns and rows.what i am
trying to do is sort all data by the date column and maintain the
corresponding row data to each date.