I have a large table of data I have to paste from a website into an Excel spreadsheet regularly. (It requires 2fa login and Data > From Web is not working).
The problem is the site has pages 1, 2... and each page has a different number of rows each time. I need to paste all pages data one after the other in the same Excel table, overwriting the existing data.
After I finish pasting the first page into the top of the Excel table, I have to scroll all the way down using the mouse roller to the point where the paste ended (where the blinking ends) to be able to paste the 2nd page.
As the table contains data already the END button doesn't work for this. Is there some other keyboard shortcut or way to get to the end of the just-pasted range?
Thanks!
The problem is the site has pages 1, 2... and each page has a different number of rows each time. I need to paste all pages data one after the other in the same Excel table, overwriting the existing data.
After I finish pasting the first page into the top of the Excel table, I have to scroll all the way down using the mouse roller to the point where the paste ended (where the blinking ends) to be able to paste the 2nd page.
As the table contains data already the END button doesn't work for this. Is there some other keyboard shortcut or way to get to the end of the just-pasted range?
Thanks!
