Forum Discussion
Repetitive cells in a table
Is there a way in Table that I can make "California" and "Los Angeles" show only one time and all the other are blank in order for easy reading?
Do I need to use macros?
Please advise. Thanks
State | City | Street | First Name | Last Name |
California | Los Angeles | Broadway | John | Smith |
California | Los Angeles | Temple Street | Sam | Sanchez |
California | Los Angeles | Grand Avenue | David | Shawn |
California | Los Angeles | Hill Street | Mary | Leung |
Sherman995 You could either delete the repetitive entries, or format the font used for them so that it is Hidden and turn off the display of hidden text,
- Sherman995Copper ContributorThis table is run under some scripts (TeamMate Plus). Is there automatic way that I can learn to check the logic to determine these entry should show or disappear? Thanks
- Charles_KenyonBronze Contributor
Doug has given you the easiest solution.
The developers of TeamMate Plus should be able to give you a report format that does this automatically.Only if you have to generate a new table every day AND TeamMate won't help should you be looking to do anything after the report has been created. You should look for a Word vba developer to help you.