+ Reply to Thread
Results 1 to 23 of 23

Splitting data into seperate spreadsheets based on column values

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-12-2012
    Location
    mysore
    MS-Off Ver
    Excel 2007
    Posts
    212

    Re: Splitting data into seperate spreadsheets based on column values

    I have several columns in the spreadsheet and I need to split the spread sheet based on any clolumn values.It could be 1,2,...or n...
    For Example
    Clo1 col2 col3 col4
    1 34 45 56
    3 45 76 67
    5 64 58 89

    If I consider col2 values I need to pot each value for example 34,45,64 in different spread sheets.

    Thanks

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

    Re: Splitting data into seperate spreadsheets based on column values

    The above code creates sheets named "34", "45" and "58" if Col2 is used, and if sheets with those names don't exist already.

    If that's not what you want, could you be more specific about just what it is that you do want?

+ 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] Counting Multiple Values in a column based on critera in seperate column
    By ERoberts in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2013, 01:08 PM
  2. Splitting out Excel data to multiple files based on one column's values
    By machos in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2011, 08:55 AM
  3. Import Data from multiple spreadsheets into seperate spreadsheets worksheet
    By cablecrt in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-17-2008, 08:01 AM
  4. Splitting data from sheets into seperate workbooks based on formula?
    By raggajunglist in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-08-2007, 10:45 AM
  5. Replies: 2
    Last Post: 02-08-2005, 04:06 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