📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

Question on automating task

Hi,

I usually copy information from a website and paste it into MS Excel/ Office (for reference purposes). As I perform this task quite often, I'm wondering whether I can use any function in MS Office/ other programs to automate the task?

Any links or suggestions will be helpful. Thanks. :beer:

Comments

  • meclive
    meclive Posts: 482
    Part of the Furniture 100 Posts Combo Breaker
    Forumite
    Is it the same site that you always copy information from? You could maybe use a macro to do this.
  • feival
    feival Posts: 469
    Part of the Furniture Combo Breaker
    Forumite
    Don't be silly! You can get Excel to automatically read data off of a website. I have been using this for a couple of years and it is great. Go the the menu: Data, Get External Data, New Web Query and it is self explanatory from there on! Good luck and enjoy.
  • feival wrote:
    Don't be silly! You can get Excel to automatically read data off of a website. I have been using this for a couple of years and it is great. Go the the menu: Data, Get External Data, New Web Query and it is self explanatory from there on! Good luck and enjoy.

    nifty that :)

    You might need to faff around with the layout, but it does exactly what you say - I just tried it!:j
    Warning ..... I'm a peri-menopausal axe-wielding maniac ;)
  • feival
    feival Posts: 469
    Part of the Furniture Combo Breaker
    Forumite
    I told you it is good. It is realtively unknown but really really useful!
  • Definitely a useful tip....been using Excel for ages but never knew of that function...

    Thanks all, especially Feival. :T
This discussion has been closed.
★ ★ ★ Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 356K Banking & Borrowing
  • 255K Reduce Debt & Boost Income
  • 456.3K Spending & Discounts
  • 248.5K Work, Benefits & Business
  • 606.2K Mortgages, Homes & Bills
  • 179.1K Life & Family
  • 264K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.2K Discuss & Feedback
  • 37.7K Read-Only Boards
Quick Search

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.