Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2013, 02:41 PM
mpdsal mpdsal is offline Sorting a Word table containing cross-references Windows XP Sorting a Word table containing cross-references Office 2007
Novice
Sorting a Word table containing cross-references
 
Join Date: Nov 2011
Posts: 19
mpdsal is on a distinguished road
Default Sorting a Word table containing cross-references

I have two separate tables in a Word 2010 template. They are identical in structure as far as headings, columns, rows, etc. In one table I have Bookmarks assigned and in the other a cross reference to that Bookmark. The last column in each table row has a background color assigned based on rating. It will can only be red, yellow, or green.

Is there a way that I can sort these tables by color and still maintain the link to the bookmark? I need it to sort red at the top followed by yellow, then green



I am open to suggestions for using VBA if it calls for this.

Thanks

Mark
Reply With Quote
  #2  
Old 02-12-2013, 11:54 PM
macropod's Avatar
macropod macropod is offline Sorting a Word table containing cross-references Windows 7 64bit Sorting a Word table containing cross-references Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Providing you're sorting the table by a given column, and not sorting the column only, the cross-references should remain valid. As for your actual sort criteria, Word won't sort by colour, so you'll either need an actual value to sort by (eg the rating value behind the colouring) or a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 02-13-2013, 08:51 AM
mpdsal mpdsal is offline Sorting a Word table containing cross-references Windows XP Sorting a Word table containing cross-references Office 2007
Novice
Sorting a Word table containing cross-references
 
Join Date: Nov 2011
Posts: 19
mpdsal is on a distinguished road
Default

macro,

Thank you for the speedy reply. In addition to the background color the rating color name also appears. So I presume I can sort on that instead of the actual color? I forgot to mention that.

Mark
Reply With Quote
  #4  
Old 02-13-2013, 05:02 PM
macropod's Avatar
macropod macropod is offline Sorting a Word table containing cross-references Windows 7 64bit Sorting a Word table containing cross-references Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Yes, you should be able to sort by name. Of course, if the alphabetic order of the names isn't the same as the ranking (eg "nil, low, medium, high, severe" would sort as "high, low, medium, nil, severe"), you might need a 'helper' column with numbers that correspond to the rankings.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 02-13-2013, 05:38 PM
mpdsal mpdsal is offline Sorting a Word table containing cross-references Windows XP Sorting a Word table containing cross-references Office 2007
Novice
Sorting a Word table containing cross-references
 
Join Date: Nov 2011
Posts: 19
mpdsal is on a distinguished road
Default

I think you're right about the helper column. Is it possible to add this column and keep it hidden? Or non-printable? I like that idea.

Mark
Reply With Quote
  #6  
Old 02-13-2013, 06:44 PM
macropod's Avatar
macropod macropod is offline Sorting a Word table containing cross-references Windows 7 64bit Sorting a Word table containing cross-references Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

You could add another column to the right of the table, clear its cell borders (except for the left one), and format its text as hidden. You can then control the column's display & printing via Word's display/print options.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formatting Cross-References in Word 2010 mpdsal Word 5 12-05-2012 04:16 PM
Caption woes with cross-references/TOFs (Word 2007) Jhimmibhob Word 0 07-27-2011 08:37 AM
MS Word cross-references? entity022 Word 3 06-03-2010 06:37 AM
Sorting a Word table containing cross-references CHALLENGE! Issue sorting data containing relative references on a separate tab lax828 Excel 3 01-07-2010 11:28 AM
Cross References egcharles Office 0 04-19-2009 06:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:37 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft