I'm trying to create an excel worksheet that takes information from a web query and adds it to a table each month when the content of the web query changes.
There is a table on a web page that contains some economic data. It changes every month. I have made a table that checks to see if the information is new (not the same as the row above) and if it is new adds the new numbers to the table with vlookup, otherwise it prints "" in each cell.
I've looked and looked, but I can't find a way to have the table save the information automatically before the contents of the table change. Say the first line is "July-10", which matches the web query today. Next month the query will change and the first line of the table will change to "Aug-10". I want to keep last month's data and add a new line whenever the web query changes.
One solution I thought of is to change the contents of the cells to their values with the F9 key every month. However, I want to make similar worksheets with many different queries that change on different days - making manually changing the cells to their values cumbersome. (What if I wanted to get the open, close, high and low prices from 10 stocks every day and add it to a table?)
Is there a better way?
FYI I don't know VBA.
There is a table on a web page that contains some economic data. It changes every month. I have made a table that checks to see if the information is new (not the same as the row above) and if it is new adds the new numbers to the table with vlookup, otherwise it prints "" in each cell.
I've looked and looked, but I can't find a way to have the table save the information automatically before the contents of the table change. Say the first line is "July-10", which matches the web query today. Next month the query will change and the first line of the table will change to "Aug-10". I want to keep last month's data and add a new line whenever the web query changes.
One solution I thought of is to change the contents of the cells to their values with the F9 key every month. However, I want to make similar worksheets with many different queries that change on different days - making manually changing the cells to their values cumbersome. (What if I wanted to get the open, close, high and low prices from 10 stocks every day and add it to a table?)
Is there a better way?
FYI I don't know VBA.