How to create websites?

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

Was this solution helpful to you?

Just Added Q & A:

Find solution

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.