Consolidate Sales Data with Power Query
Budget: $30 – $250 AUD
Please read the instructions attached before bidding for work. You need to be able to do this in powerquery or another automated way because the spreadsheet needs to be updated daily.
I need help to consolidate my sales data from multiple Excel sheets into one spreadsheet. The data is structured in tables within these sheets.
The main spreadsheet will have 3 letter codes. I need you to search these three codes into a folder and pull a tab from the excel file.
I need help to consolidate my sales data from multiple Excel sheets into one spreadsheet. The data is structured in tables within these sheets.
The main spreadsheet will have 3 letter codes. I need you to search these three codes into a folder and pull a tab from the excel file.