Hi Guys, Find attached a simple web query that is currently being refreshed every minute. For the life of me, I am unable to figure out how to have new "refreshed" data placed directly below the previous data. In anycase, I realized that this would not solve all my issues. Here is what I am ultimatly looking for with a macro: 1. Once Data is refreshed in column "B", only pertaining data that was just refreshed would have a date & time stamp in the corresponding "A" column. 2. All further refreshed data would be place below the previously reshed data, again with date and time stamp in column "A"... so on and so forth. 3. Automatic saving is to take place every 30 minutes. 4. Once or if 60,000 rows are encountered, it would go to the next available blank worksheet. Thank you.
-- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
TEST-001.xls
Description: MS-Excel spreadsheet
