Hi all,
I wonder if you guys can stop a laptop being thrown out of a window.... I've got no patience with trying to do this sort of thing, there's tons of information out there, but none of it quite matches what I'm trying to achieve..
A bit of background, I've created a Power Query that reads data from .json files (these can vary, 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 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.
There is already some 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....?
Would really appreciate any pointers
I wonder if you guys can stop a laptop being thrown out of a window.... I've got no patience with trying to do this sort of thing, there's tons of information out there, but none of it quite matches what I'm trying to achieve..
A bit of background, I've created a Power Query that reads data from .json files (these can vary, 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 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.
There is already some 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....?
Would really appreciate any pointers
