Sorting Tables in Order
I would love some advice/pointers on the following problem please!
Our users use a Word Document to record Contact Session details, each
contact session takes place on a different day and various detail about these
sessions are recorded in a table.
For every new session that takes place a new table within the document is
created. Within this document, I have previously created a macro which will
automatically create a new table and format it as with specific questions for
the end user to complete.
Within this automatically created table is an ActiveX DTpicker, by which the
user can select the date that the contact session took place.
My end users now want a process to be created whereby the tables are sorted
in chronological order by use of a Macro as the fear is that if one worker
fails to enter their contact session details in a timely fashion (i.e. before
the next session takes place) then the order can become out of order.
Although I have an idea of what I want to do I can’t work out the most
efficient way of doing this and hoped that someone cleverer or more
experienced might point to the right direction (i.e. the most efficient way
of achieving this goal.)
So far, whilst experimenting I have managed to feed all dates from all
tables in to a variable array, and my plan is to work out a way of comparing
these variables (i.e. put them in order) and then cut and paste the tables to
comply with this order.
Any advice or help or examples or words of encouragement will go a long way.
||2/26/2010 11:32:01 AM
(page loaded in 0.027 seconds)
Sorting Tables in Order - microsoft.public.word.vba.general ...
Greetings all, I would love some advice/pointers on the following problem please! Our users use a Word Document to record Contact Session detail...
Sorting tables on protected worksheets - microsoft.public.excel ...
How do we configure our worksheet so that we can turn protection ON, but still enable the table filter buttons in order to sort columns in a table? ...
Sorting the pivot table field list - microsoft.public.excel ...
How do I sort the pivot table field list? It looks like the soft order is always the order of the data source. The related radio-buttons in the ...
pivot table sorting - microsoft.public.excel.charting
Excel Pivot Table Sorting... the items in a pivot table field, so new items are in alphabetical order; sort pivot ... Pivot Tables - Subtotals, Create Multiple Pivot ...
Table of Authorities entry sorting - microsoft.public.word ...
Is there a way to change the sort order of entries generated in the Table of Authorities (Word 2007)? I need the entries to list in order of firs...
Sort months in calendar order - microsoft.public.access.reports ...
From my Invoices table, I have a query that groups our charges together by month and then shows each month with its respective total revenue. I use t...
Sorting in Pivot Charts - microsoft.public.access.forms ...
Sorting the pivot table field list - microsoft.public.excel ... Sorting Pivot Table Report Fields - Excel Pivot Tables How can you change the sort order, to put the ...
Pivot Table Month Order - microsoft.public.excel.misc
The problem is you are using month names, which Excel, naturally sorts into alphabetical order. Your choices are: 1. Use month numbers -- at least they will sort ...
Sort Table With only the latest date - microsoft.public.access ...
Sorting Tables in Order - microsoft.public.word.vba.general ... Sort Table With only the latest date - microsoft.public.access ... I have two columns with text only and ...
Sorting Count Values in Pivot Table (Excel 2007) - microsoft ...
I would like to be able to sort a pivot table by it's count values. I'm using Excel 2007. ... want to sort by Supplier and then by Count of Location descending order ...
Sorting Repeating Tables in Order Forms Programmatically with ...
Summary: Learn how to add managed code to sort the table in an InfoPath browser form, and then publish it back to SharePoint Server 2010 as a sandboxed solution.
How to Sort a Table in Ascending Order in Microsoft Word | eHow.com
Word's sorting tool, often used for alphabetizing bibliographies or other text-based lists, can also sort numerical information in lists or in tables. You can even ...
About sorting - Word - Office.com - Microsoft Corporation ...
You can sort text, numbers, or data in ascending order (A to Z, zero to 9, or earliest to latest date) in lists or tables. Or, you can sort in descending order (Z to ...
Help:Sorting - Wikipedia, the free encyclopedia
It is a good idea to keep lists and tables in some kind of initial non-random sort order. Numbered rank order can be difficult to maintain as the list is updated, and as ...
Save a sort order with a table, query, form, or report - Access ...7/28/2012 7:23:08 PM
When you sort the data in a table, query, form, or report, you can save the sort order with the object. If you sort the data in one of these objects and then save the ...