+ Reply to Thread
Results 1 to 4 of 4

Split data into separate worksheets and sort

  1. #1
    Registered User
    Join Date
    07-12-2012
    Location
    rochester, ny
    MS-Off Ver
    Excel 2007
    Posts
    5

    Split data into separate worksheets and sort

    Hello. I am looking for vba code or a macro to split some data up into separate worksheets. I would like to move the data into sheets separated by source address in column C. If those pages can be put in order and the data on each individual worksheet can be put in order by time that would be great. Also were would be a great place to get some insight on how to write these types of macros myself?

    Thanks eveyrone.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Split data into separate worksheets and sort

    Hi jmx1092,
    Try this code :

    Please Login or Register  to view this content.
    Good place to learn is with the examples you can find on the forum. There are also many good reference books. Two of my favorites : "Excel 2007 VBA Programmer's Reference" and "Professional Excel Development"

    Cheers.
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,525

    Re: Split data into separate worksheets and sort

    Quote Originally Posted by jxm1092 View Post
    and the data on each individual worksheet can be put in order by time that would be great. Also were would be a great place to get some insight on how to write these types of macros myself?

    Thanks eveyrone.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  4. #4
    Valued Forum Contributor
    Join Date
    03-21-2013
    Location
    cyberia
    MS-Off Ver
    Excel 2007
    Posts
    457

    Re: Split data into separate worksheets and sort

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Split worksheets to separate files
    By ksteffin in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-10-2013, 06:04 AM
  2. Replies: 1
    Last Post: 03-29-2013, 03:06 PM
  3. Split data by Criteria into separate worksheets on one workbook
    By TrebleC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-05-2013, 08:39 AM
  4. Split into Separate Worksheets
    By bigroo1958 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-15-2010, 10:54 AM
  5. Split my data into separate worksheets
    By drunk8gods in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2010, 04:20 PM

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