You are reading a single comment by @hugo7 and its replies.
Click here to read the full conversation.
-
This is, nowadays, often the answer.
Most of my previous data collecting, cleaning and collating stuff which would be done with SQL and macros and shit are now done much more easily via Power Query.
I do still have issues with it though. Not being able to dynamically locate a source file based on %userprofile% is annoying as is not being able to import CSV files from Onedrive.
aggi
@hugo7
Are you going to say put it into another sheet and power query all the things?