Sort Macro Button

T

Thomas

I have a small table (15 rows, 5 columns) that will be completed by clerks.
I need to click a button at the bottom of the screen that re-sorts the table
based on the values in column 4 (Not all rows are completed at all times).
How can I:
1). Add a button that runs a macro to sort a table based on a columns value?
2). Have the macro ignore rows without a value?
Thanks,
Thomas
 
D

Doug Robbins - Word MVP on news.microsoft.com

See the article "Using MacroButton fields" at:

http://www.word.mvps.org/FAQs/TblsFldsFms/UsingMacroButton.htm

The easiest way to deal with the empty rows would be to have the macro
delete them (and if necessary, after the sort, add rows to the bottom of the
table so that the total number of rows is restored.)


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top