|
|
#11
07-19-2018, 05:58 PM
|
||||
|
||||
Copy the attached document to the same folder as your Dummy.xlsm workbook, then open the document. Pressing Ctrl-A, F9 will cause the two lists in the document to refresh any time updates to the workbook are saved. The lists are generated by DATABASE fields in the document, for which the field code display can be toggled on/off via Alt-F9. For more on DATABASE fields, see: https://support.office.com/en-us/art...9-558a87badcbc
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Tags |
| advanced filters, excel 2016, macro |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Finding Capital Letters and filtering them out in an excel sheet
|
ch1325 | Excel | 4 | 08-20-2015 07:25 AM |
|
Filtering (advanced?) in Pivot Table
|
canajun | Excel | 6 | 01-17-2015 05:01 AM |
| Need help in automating data from multiple sheets into a single sheet | veedee | Excel Programming | 8 | 06-12-2014 10:04 PM |
|
Need help in automating data from multiple sheets into a single sheet
|
veedee | Excel | 1 | 06-11-2014 04:01 AM |
| Automating document updates with new text | wordfoolish2 | Word | 0 | 01-04-2011 01:01 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode