+ Reply to Thread
Results 1 to 2 of 2

Fast CopyPaste from web to excel

  1. #1
    Registered User
    Join Date
    11-08-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    46

    Fast CopyPaste from web to excel

    I need to collect info from web and by hand, I cannot use any script/crawler because some information is very disorderly.

    I have to use copy paste method

    I'm looking for faster way to Copy Paste information from web to excel. Is there such a way to Paste information straight from web to excel. So I can only stay in the web browser.

    The data what I have to collect is phone numbers from auction item description. There is lots of text and phone number somewhere.


    This method will be very good if I can activate the text (phone number) and choose CTRL+A+1 and this will Paste this phone number to cell A1 in Excel. Then I go to next auction and find phone number and activate it and choose CTRL+B+1 and this will Paste this phone number to cell B1 in Excel.

    Something like that. Command can be different.

  2. #2
    Forum Contributor
    Join Date
    02-04-2014
    Location
    NSW, Australia
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: Fast CopyPaste from web to excel

    I cant remember how it is done anymore, but a loooooong time ago.... I had to "link" stock exchange numbers into excel, it was good as I could refresh the data easily. I apologise for not having a direct answer - but possibly you could follow up on something along these lines?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Code to copypaste large data in same worksheet
    By caooi23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-28-2015, 02:33 AM
  2. Copypaste after conditions are met
    By Naveen900 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-14-2015, 02:49 AM
  3. CopyPaste-HARD stuff
    By MotoXcel90 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-05-2014, 10:45 AM
  4. [SOLVED] DropBox value triggering copypaste by "SEARCHING" for the correct cells to copypaste
    By tnuis in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-03-2013, 09:41 AM
  5. Error Generation during copypaste macro run
    By ravinder_tigh in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-26-2009, 01:00 AM
  6. CopyPaste
    By Ivica Lopar in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-21-2005, 08:40 PM
  7. [SOLVED] FormatConditions appears to kill copypaste
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1