How to print the drop down menue when filtering an Excel sheet
Thread poster: Klaus Urban

Klaus Urban  Identity Verified
Local time: 18:45
Member (2005)
English to German
+ ...
Aug 23, 2009

In connection with my various translations of English rose books into German, I have compiled a very comprehensice data base of rose names and synonyms, currently 25,000 entries. Printing out would result in 500 pages.
Filtering the column "breeder" shows a drop down menue of breeders in alphabetical order. Can I print this alphabetical list (800-1000 names, approx. 20-25 pages)?
I need this to cross check against a separate data base of breeders.
Any help will be most welcome.
Klaus


 

Harry Bornemann  Identity Verified
Mexico
English to German
+ ...
Copy to Access Aug 23, 2009

I would copy the column "breeder" into an empty Access table (or open the Excel file in Access) and then apply a simple grouping query, with sorting.
Harry


 

Hynek Palatin  Identity Verified
Czech Republic
Local time: 18:45
English to Czech
+ ...
Filter unique records Aug 23, 2009

Use Advanced filter in Excel, here is how:
http://www.contextures.com/xladvfilter01.html#FilterUR


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

How to print the drop down menue when filtering an Excel sheet

Advanced search






SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search