Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
organizing data on the fly to access certain infomation
I have different fields in my columns i.e. name, date, time. I need to find
like names and place them together, or, like dates and place them together while keeping my rows intact. I need to be able to organize this information when ever I want and however I choose according to the different fields with out compromising the integraty of the rows. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
organizing data on the fly to access certain infomation
Take a look at Data Filter AutoFilter...........
Vaya con Dios, Chuck, CABGx3 "10john01" wrote: I have different fields in my columns i.e. name, date, time. I need to find like names and place them together, or, like dates and place them together while keeping my rows intact. I need to be able to organize this information when ever I want and however I choose according to the different fields with out compromising the integraty of the rows. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
organizing data on the fly to access certain infomation
Hi John
You could mark your entire block of data, and sort by name, date or time. Providing you mark the complete range, the integrity of each row will be maintained. There is also some very nice code written by Dave Peterson, which creates shapes to encompass the data, and just clicking on the column header will automatically sort the data correctly by that column, clicking it again sorts in the opposite direction. The code and a download of an example file can be found on Debra Dalgleish's site http://www.contextures.com/xlSort02.html -- Regards Roger Govier "10john01" wrote in message ... I have different fields in my columns i.e. name, date, time. I need to find like names and place them together, or, like dates and place them together while keeping my rows intact. I need to be able to organize this information when ever I want and however I choose according to the different fields with out compromising the integraty of the rows. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
populating spreedsheet with data from access | Excel Worksheet Functions | |||
Data from Excel to Access Table | Excel Discussion (Misc queries) | |||
How to import data from a password protected Access DB into Excel. | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
How do I get an Access form in Excel to Expand the Data | Excel Discussion (Misc queries) |