Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format column to automatically move rows to date order
I am way behind in my checkbook register. I want to be able to enter the
information from several sources - check register, slips of paper, reciepts and bank statements in what ever order I find them but have the spreadsheet automatically move the rows into the correct date order. Is there a formula for this? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
format column to automatically move rows to date order
Not a formula, but you can sort by date. Make sure that before you invoke
the sort you select the range of data to include in the sort, including all the relevant rows and columns. -- David Biddulph "Mark Kruger" wrote in message ... I am way behind in my checkbook register. I want to be able to enter the information from several sources - check register, slips of paper, reciepts and bank statements in what ever order I find them but have the spreadsheet automatically move the rows into the correct date order. Is there a formula for this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically move cursor to top of a column | Excel Discussion (Misc queries) | |||
how do i automatically move data from rows to columns? | Excel Discussion (Misc queries) | |||
Getting Pivot Tables to automatically sort rows in alphabetical order | Excel Discussion (Misc queries) | |||
sort rows in alphabetical order and move the corresponding data | Excel Worksheet Functions | |||
Date in descending order to come up automatically in a column? | Excel Worksheet Functions |