+ Reply to Thread
Results 1 to 2 of 2

Macro to Split Data into separate sheets

  1. #1
    Registered User
    Join Date
    03-20-2012
    Location
    Fremont, CA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Macro to Split Data into separate sheets

    Hi I have a working macro that takes data and splits it into a worksheet for each number in a column. I can get it to work on a separate sheet with dummy data but not on the actual workbook I use at work. There are numerous other macros working on this worksheet as well as several referenced cells within the segment I am trying to run the macro on. I am not sure if that would cause a problem. The part of the worksheet I want it to run on is E37:J70. The error I am seeing when trying to run is: "Run Time Error 1004 Cannot rename a sheet to the same name as another sheet, a referenced object library or a workbook referenced by Visual Basic."

    Another issue is when the data splits the worksheets are ordered backwards with the highest number first and so forth.

    Thanks for your help.

    Here is the VBA:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert 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: Macro to Split Data into separate sheets

    Hi zahinullah

    Welcome to the Forum!!

    It'll probably be something like this (untested as I don't have your Workbook
    Please Login or Register  to view this content.
    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.

+ 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. Vba macro to split the data to three sheets depends upon single & repeats
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2013, 10:54 AM
  2. Macro to Split Data Onto Separate Sheets
    By kestefon in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-20-2013, 11:02 AM
  3. [SOLVED] Need to split a LONG list into separate sheets based on repeating, incremental nunbers
    By matrix_machine in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-31-2012, 04:37 PM
  4. [SOLVED] Split Macro modification to Split into new Workbooks instead of sheets within one workbook
    By DLSmith in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-13-2012, 08:11 PM
  5. Macro to delete data on separate sheets
    By nohero in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-15-2011, 02:15 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