Thread: Automating Updates For Advanced Filtering Into New Sheet
View Single Post
 
Old 07-19-2018, 05:58 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
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
Attached Files
File Type: docx Data Extract.docx (38.4 KB, 9 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote