+ Reply to Thread
Results 1 to 3 of 3

sorting data Macro...

  1. #1
    Forum Contributor
    Join Date
    06-21-2006
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2007
    Posts
    108

    sorting data Macro...

    Hi, I wonder if anyone could help me with a macro. Attached is a raw report from a telephone system. I need a macro which would pick out data from that sheet and put it on a new tab. The details I need are the name, the FIRST Login time, and the LAST log out time, as there will more than often be 2 lots of log in/outs at least.
    I need the name in column A, the log in time on column B and the log out time on column C. Is this do-able and fairly easy?

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-23-2005
    Location
    Rome
    MS-Off Ver
    Ms Office 2016
    Posts
    1,628
    See Macro1 in attached file. It will put data from sheet1 to sheet2.

    I hope it's what you need.

    Regards,
    Antonio
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    06-21-2006
    Location
    Sheffield, England
    MS-Off Ver
    Excel 2007
    Posts
    108
    It's exactly what I need!!!

    Thanks Antonio.


+ 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