Automating Updates For Advanced Filtering Into New Sheet

macropod · #13 07-23-2018, 04:08 PM

If you open the document and press Alt-F9, you will see the DATABASE field codes, the first of which looks like:

Code:

{DATABASE \d "{FILENAME \p}/../Dummy.xlsm" \s "SELECT `Flat/Door Number`, [Address First Line]&''&[Address Second Line] &''&[District]&', '&[City]&' '&[Postcode] As `Address, Locality & Postcode`, `URC`, `Ref Code`, `Eligibility` FROM [Data$] WHERE [Eligibility] = 'Registered' " \b 58 \l 9 \h }

Simply replace 'Dummy.xlsm' with the correct file name and save the Word document to the same folder as that file.

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