+ Reply to Thread
Results 1 to 8 of 8

Split Worksheet into Several Worksheets using multiple columns

  1. #1
    Registered User
    Join Date
    09-20-2011
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2010
    Posts
    4

    Split Worksheet into Several Worksheets using multiple columns

    Good afternoon! I am new to this so I am going to try and make this as simple as possible....

    I have a worksheet that has 100 columns... Is there a way to break every 3 columns into a seperate worksheet. For example...

    CurrentWorksheet...

    Column A is blank
    Column B contains dates
    Column C contains dollar amount
    Column D is blank
    Column E contains dates
    Column F contains dollar amount
    etc...

    I Need...

    Sheet1
    Column A is blank
    Column B contains dates
    Column C contains dollar amount

    Sheet2
    Column A is blank
    Column B contains dates
    Column C contains dollar amount

    Sheet3
    Column A is blank
    Column B contains dates
    Column C contains dollar amount, etc....
    Last edited by WBarrett; 09-21-2011 at 03:16 PM.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202

    Re: Split Worksheet into Several Worksheets using multiple columns

    To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

    If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

    Doing this will ensure you get the result you need!
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    09-20-2011
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Split Worksheet into Several Worksheets using multiple columns

    Thanks

    I am trying to take the first tab on the attached example and split it into multiple tabs. The end result should be the last 5 tabs (team1-team5)...Is this possible?
    Attached Files Attached Files

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Split Worksheet into Several Worksheets using multiple columns

    Hi WBarrett

    What happened to the blank columns? The file you uploaded doesn't match the sheet layout of your original post.

    Does the structure of the file you uploaded represent the structure of your actual data file?
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Registered User
    Join Date
    09-20-2011
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Split Worksheet into Several Worksheets using multiple columns

    You are correct! I have updated the attachment to match the original comment
    Attached Files Attached Files

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Split Worksheet into Several Worksheets using multiple columns

    Hi WBarrett

    This code in the attached and appears to do as you require.
    Please Login or Register  to view this content.
    Let me know of issues.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-20-2011
    Location
    Jacksonville, Fl
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Split Worksheet into Several Worksheets using multiple columns

    Thank you so much!

  8. #8
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: Split Worksheet into Several Worksheets using multiple columns

    Hi WBarrett

    Glad I could help.

+ 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