+ Reply to Thread
Results 1 to 2 of 2

Help sorting data from one tab into seperate tabs by date field

  1. #1
    Registered User
    Join Date
    07-16-2009
    Location
    Boston, MA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Help sorting data from one tab into seperate tabs by date field

    Hi everyone, I'm brand new to VBA. Any help is greatly appreciated.

    I have a spreadsheet that is filled with log data of a sensor taken in three minute intervals over the course of the past several days. I've been manually selecting, copying and pasting into new tabs by each day. I'm going to have to do a lot of this so I was hoping there might be a way I could do this more efficiently.

    To help make this more clear I've attached two files. Before and After.

    I want to take the "Before" file and automatically turn it into the "After"

    Thanks guys!

    -KC
    Attached Files Attached Files

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Help sorting data from one tab into seperate tabs by date field

    Why? For almost any analysis you want to do, it would be better to keep the data all on one sheet.

    It would be good to convert the text represenation of data an time to a standard Excel date, which you could do in a separate column, and then paste values over the original data:

    In C2 and down, =RIGHT(A2, 5) + LEFT(A2, 8)
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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