+ Reply to Thread
Results 1 to 14 of 14

Split Data based on 3 Columns into separate worksheets

Hybrid View

  1. 05-24-2014, 03:49 AM #1
    PCI
    PCI is offline
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,085

    Re: Split Data based on 3 Columns into separate worksheets

    An issue is the sheet's name length : maxi = 30
    Do a test with your data
    Reply With QuoteRegister To Reply
  2. 05-28-2014, 08:29 AM #2
    angeleenmc
    angeleenmc is offline
    Registered User
    Join Date
    05-21-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    43

    Re: Split Data based on 3 Columns into separate worksheets

    how do I change the count? It is now highlighting 'Worksheets(Worksheets.Count).Name = G' in yellow.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split data into separate worksheets and sort
    By jxm1092 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2013, 05:00 AM
  2. 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
  3. How to split excel file into separate workbooks based on number of columns?
    By nandana83 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-31-2012, 04:03 AM
  4. Split my data into separate worksheets
    By drunk8gods in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-12-2010, 04:20 PM
  5. Excel 2007 : How to split mixed data into 2 separate columns?
    By LearnerEXL in forum Excel General
    Replies: 2
    Last Post: 09-24-2009, 06:51 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1