VBA to refresh Power Query Editor > json and pull in values onto a new row using a single button in a cell
Budget: £10 – £20 GBP
I've got an existing .xlsm spreadsheet that I want to automate.
I've created a Power Query that reads data from a .json file (the location of these can alter, but I'm comfortable with pointing it to the correct one when required, but for the most part it will need to be the same .json refreshed periodically). The data that is pulled in requires converting which I've set up using a series of lookup tables. The resulting values then need to be copied from a common source on another sheet and pasted into a new row on the first sheet of the same workbook each time with a date/time stamp added.
I was hoping I could achieve this by adding a button (in column A) that would perform this task and then move down a row ready for the next update.
The spreadsheet has some existing code which fills rows 3 & 4 and then calculates the difference using the 'Set' button.. I was hoping to use the same kind of thing....?
I've created a Power Query that reads data from a .json file (the location of these can alter, but I'm comfortable with pointing it to the correct one when required, but for the most part it will need to be the same .json refreshed periodically). The data that is pulled in requires converting which I've set up using a series of lookup tables. The resulting values then need to be copied from a common source on another sheet and pasted into a new row on the first sheet of the same workbook each time with a date/time stamp added.
I was hoping I could achieve this by adding a button (in column A) that would perform this task and then move down a row ready for the next update.
The spreadsheet has some existing code which fills rows 3 & 4 and then calculates the difference using the 'Set' button.. I was hoping to use the same kind of thing....?