Logging web data excel
Closed
Excelneebie
Posts
1
Registration date
Tuesday January 9, 2018
Status
Member
Last seen
January 9, 2018
-
Jan 9, 2018 at 02:08 PM
Blocked Profile - Jan 9, 2018 at 05:15 PM
Blocked Profile - Jan 9, 2018 at 05:15 PM
I’m trying to log some data imported from the web. I’ve already managed to import the data as a table and set an auto refresh to every minute. What I now need is after an auto refresh, for each row of the data to appear in a separate sheet within the workbook and appear on the row below the last. This would mean that after one hour, I would have a series of sheets with 60 rows of data. I’d like to run it for a full day. I hope that makes sense. It must be possible but beyond my VBA skills. I’m very grateful for any advice.
Related:
- Logging web data excel
- Instagram keeps logging me out - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- Tmobile data check - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Number to words in excel - Guide
1 response
That is not a free question. We are volunteers. I would recommend that you perform the follwoing, and go from here:
Write (record) a macro that take the current tab, copies it, and moves it to the end of the book.
Write a macro that starts a new tab. PLace the current data conection, onto the new tab.
Do that, and post back if you have any issues tieing them back together in a scheduled task!
Write (record) a macro that take the current tab, copies it, and moves it to the end of the book.
Write a macro that starts a new tab. PLace the current data conection, onto the new tab.
Do that, and post back if you have any issues tieing them back together in a scheduled task!
Jan 9, 2018 at 05:08 PM
Jan 9, 2018 at 05:15 PM