+ Reply to Thread
Results 1 to 14 of 14

Split Data based on 3 Columns into separate worksheets

Hybrid View

  1. 05-28-2014, 09:35 AM #1
    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

    Here you go. Let me know if you need anything else.

    Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 05-29-2014, 06:17 AM #2
    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

    See here your file.
    I added an additional column to get the ADVERTISER name shorter
    I removed ome sheets for file size issue to download
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 05-29-2014, 08:52 AM #3
    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

    I'm coming back to the origine macro and file.
    Everything is working correctly: Remove the spaces in end of ADVERTISER's names
    Attached Files Attached Files
    Last edited by PCI; 05-29-2014 at 09:02 AM. Reason: Typo
    Reply With QuoteRegister To Reply
  4. 05-29-2014, 09:32 AM #4
    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

    Thank you! How do I do that quickly on all columns that apply?
    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