How do I use excel to create a spreadsheet from multiple websites that use different formats for data?
-
I am trying to create a spread sheet that pulls data from multiple websites, some of the sites use excel some are just web based listings. I would also like to be able to get the spreadsheet updated as the websites are refreshed.
-
Answer:
Personally, I would probably do this in MS-Access, because I could import the data into Tables and compare the new data against the already existing data. And it would make the manipulation of the various formats much easier. Either way (Excel or Access), to have this automatically update your data, based upon changes at those various websites, will take a lot of VBA coding and interfacing. And that means a major project!!!! If you want to do more of the basic manual data-manipulation yourself, then it will not take as much programming and design. But it will be a lot of daily work.
Nicole T at Yahoo! Answers Visit the source
Related Q & A:
- How can I use real time social data from Datasift and perform real time analytics on it?Best solution by Quora
- How do I use auto-increment within a trigger?Best solution by dba.stackexchange.com
- How can I use my PC with a wireless printer?Best solution by pcmag.com
- How can i use my laptop as a monitor for my xbox 360?Best solution by Yahoo! Answers
- How do I use my TV as a second monitor?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.