Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting columns by date
I am creating a spreadsheet and I am having difficulty applying a formula to
auto-arrange a column by date. My goal is to have the information sorted by date (soonest first) regaurdless of when the data is entered into the spreadsheet. I would really appreciate any help on this. Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formatting columns by date
Hi
I would suggest simply re-sorting the list after each session. It would be possible to do it automatically with a macro but you'd still have to hit a button to tell it to run. You might as well record a macro while you do the sort and stick a button for it on your toolbar. Hope this helps. Andy. "JR Jen" <JR wrote in message ... I am creating a spreadsheet and I am having difficulty applying a formula to auto-arrange a column by date. My goal is to have the information sorted by date (soonest first) regaurdless of when the data is entered into the spreadsheet. I would really appreciate any help on this. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on date range | Excel Discussion (Misc queries) | |||
Formatting and Grouping Columns | Excel Discussion (Misc queries) | |||
Value between 2 dates | Excel Worksheet Functions | |||
Date formatting problem | Excel Discussion (Misc queries) | |||
Date Formatting | Excel Discussion (Misc queries) |