2008-06-04, 21:48 #1
- Join Date
- Jan 2008
- Thanked 0 Times in 0 Posts
How to sort 'Records' without a table (2003)
I have a template in which the user enters real estate deeds.
The deeds are bookmarked in the order they are inserted from autotext.
I'm looking for the best way to sort the deeds by "filed date" (a field in each deed record), in case they are entered out of order, so the user doesn't have to delete the deeds and re-enter them.
Should I try to add the deeds to an expandable table, instead of bookmarking them, then modify the built in sort function?
Is there maybe a good way to copy each deed to the clipboard, then delete all the deeds and insert them in order?
Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!
+ Get this BONUS — free!
Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!
2008-06-04, 22:16 #2
- Join Date
- Mar 2002
- Thanked 16 Times in 16 Posts
Re: How to sort 'Records' without a table (2003)
Assuming that this is the same template that we've discussed before, I don't see a good way to do this, the structure of the document is not very suitable for it.
It might be better to let the user enter the information about deeds etc. in an Access database or Excel worksheet, and to use code to generate the document from this information. When this "meta-information" changes, simply ditch the existing document and generate a new document from scratch. This would be a *lot* of work, but in the end you'd have a much more flexible setup.