Hi,
I have a daily download of data that have all been saved into one folder.
I'd like to combine all of these into a Master sheet and may I ask if there is a way of doing this DAILY and automated?
I can use powerquery to merge, however I would like to have one sheet (say called master.xls) that I can open, and press a command button (linked to code) that will look in that directory, import/combine all files into the Master sheet but ONLY if it hasn't already imported them. So, in other words, it will just keep appending the new daily file.
Is that possible please?
I have a daily download of data that have all been saved into one folder.
I'd like to combine all of these into a Master sheet and may I ask if there is a way of doing this DAILY and automated?
I can use powerquery to merge, however I would like to have one sheet (say called master.xls) that I can open, and press a command button (linked to code) that will look in that directory, import/combine all files into the Master sheet but ONLY if it hasn't already imported them. So, in other words, it will just keep appending the new daily file.
Is that possible please?
