+ Reply to Thread
Results 1 to 4 of 4

How to extract specific data from a copy/paste from a webpage to excel.

  1. #1
    Registered User
    Join Date
    07-29-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    8

    Exclamation How to extract specific data from a copy/paste from a webpage to excel.

    I work from home doing tech support for a large chain.

    Every call i take and solve i get a solution report that is posted on my profile (web site)

    here is a picture of what i would normally see.
    SS1.PNG
    so i copy from the page the entire contents. It looks like this..
    ss2.PNG
    I then paste that into either Word or Excel like this (excel used since thats my goal here).
    ss3.PNG

    What i need to do is select the cells after pasting into excel the dollar amounts that are after the "you earn:" as seen in cells A13 and A14.
    I would like to them add them to another sheet and tabulate these amounts so i can keep a running total of what i am earning.
    I have tried find select with no luck since the fields that i need are duplicated. i just need to select the amount i earned (always the same as the amounts in (XX.XX) fields.

    I hope this explains what i want to do enough.
    Please advise if you need any more info and thanks SO MUCH for taking your time to answer these questions on this board!
    Joshua B.
    Last edited by easy365online; 07-29-2012 at 09:54 AM. Reason: Im a N00b and did not read the rules.

  2. #2
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: New to this forum - Need help badly

    Hello easy365online, and welcome to the forum.

    Thanks for amending your thread title.
    Last edited by Cutter; 07-29-2012 at 12:12 PM. Reason: Removed title change request

  3. #3
    Registered User
    Join Date
    07-29-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: New to this forum - Need help badly

    Done. Thank you.

  4. #4
    Registered User
    Join Date
    07-29-2012
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: How to extract specific data from a copy/paste from a webpage to excel.

    bump since this was marked with comments it may get lost in the shuffle.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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