Sorting Tables in Order

  • Follow


Greetings all,

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.

Thanks all!

0
Reply Utf 2/26/2010 11:32:01 AM


0 Replies
334 Views

(page loaded in 0.027 seconds)

Similiar Articles:
















7/28/2012 7:23:08 PM


Reply: