+ Reply to Thread
Results 1 to 1 of 1

Copy&Paste Certain Data Contained in Rows

  1. #1
    Registered User
    Join Date
    11-17-2011
    Location
    Indiana, US
    MS-Off Ver
    Excel 2010
    Posts
    1

    Talking Copy&Paste Certain Data Contained in Rows

    Hey guys, I'm new to VBA and this has taken me way too long already and was wondering if you guys could shed some insight. I have a data set that I am copying and pasting the values from a webpage into excel. The data is clock ins/outs generated by our timeclock. Basically i need to go through each row and extract clock-ins/outs info. I need to arrange this data in a logical manner via a macro that will go through all the rows copy, paste, and sort the necessary data. I attached an excel spreadsheet of the raw data I copied and pasted off our website as well as a screenshot of what desired result im looking for. Im having trouble telling the macro which info belongs where. Originally i set it up to set A1 to active cell, manipulate that data and paste it where i desire then delete the cell and shift up. Do the same thing with the next cell..incredible inefficient i just dont know how else to do it. Any help would be appreciated!
    Attached Files Attached Files

+ 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