View Single Post
 
Old 08-25-2020, 01:32 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

You have 2 options as far as i know, but both will require some setup work.

1) VBA.
A macro could easily open an extract and combine data into 1 report with index and match, but you would need to know the file path and name and then be able to code it. not particularly hard but if you have never used VBA you would have a fairly steep learning curve


2) Power Query
As I said before I don’t know a lot about power query but from what i have read you can import extracts from a folder and hit refresh and the combining will be done - you would obviously need to do it once and set it up but then I should be a fairly quick refresh.
Reply With Quote