…and a Power Query offering. Right-click the table and choose Refresh to update, after putting the correct path and file name into cell A1 (which is a named range 'Source')
It doesn't have to be this way; if you're having to do this on a regular basis the path can be built in. It can even be set up to process multiple files, and/or just appropriate file(s) it finds in a location at the time of the refresh. The refresh can be automatically periodic or on workbook open. No macro in the attached.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote