I need help in Excel. I have two spreadsheets A and B. A resides on my local computer, and it needs to get data from spreadsheet B. B resides on the internet, and it's data is updated every 30 minutes. Sheet A will be distributed throughout a workgroup. I need to know how to get the data from B into A. I cannot do a web query since it is looking for data contained in tables in an html file. I DO NOT want to copy and paste every 30 minutes from B into A and then redistribute. Do any of you have an answer?
Question
thumper
I need help in Excel. I have two spreadsheets A and B. A resides on my local computer, and it needs to get data from spreadsheet B. B resides on the internet, and it's data is updated every 30 minutes. Sheet A will be distributed throughout a workgroup. I need to know how to get the data from B into A. I cannot do a web query since it is looking for data contained in tables in an html file. I DO NOT want to copy and paste every 30 minutes from B into A and then redistribute. Do any of you have an answer?
Link to comment
Share on other sites
3 answers to this question
Recommended Posts