Hello, I hope this is the right sub-forum for this question. This is what I am trying to accomplish.

I receive a report every day that has 71 columns of data. The majority of this data is useless to me, but a good chunk is very important for my day to day operations. I would like to figure out a way that I can load the new daily report (CSV file) into the existing Table (Table 1) by either dragging & dropping, or a way to update Table 1 data with information from a new CSV file without excel creating a whole new Table.

And then in Table 2 on another sheet, I've already linked the respective 20 columns of data I need to the existing data on Table 1.
  • The report is laid out exactly the same every day
  • Sometimes there is 200 rows, sometimes there 3

I've tried doing Power Query but every time I load the new daily CSV it automatically creates a new table and my 20 column table I have ends up being irrelevant.

Is there a way to accomplish this? I can very much google the steps on how to accomplish it, but I'm stuck on how to import fresh data every day.

Thank you, everyone!