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!
Bookmarks