+ Reply to Thread
Results 1 to 3 of 3

how to split data into different worksheet

  1. 07-28-2015, 04:09 AM #1
    fluffyvampirekitten
    fluffyvampirekitten is offline
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    66

    how to split data into different worksheet

    I have this worksheet"Test" and in this worksheet
    - I have this column "R" which holds certain values ( America , India , Canada , Japan)
    - I want to copy/paste all the "America" rows in "America Worksheet"- Need to create new worksheet
    - I want to copy/paste all the "India" rows in "India Worksheet"- Need to create new worksheet
    - I want to copy/paste all the "Canada" rows in "Canada Worksheet"- Need to create new worksheet
    - I want to copy/paste all the "Japan" rows in "Japan" Worksheet"- Need to create new worksheet

    Any suggestion on how to do this ?
    vba?
    Thanks in advance
    Last edited by fluffyvampirekitten; 07-28-2015 at 04:46 AM.
    Reply With QuoteRegister To Reply
  2. 07-28-2015, 04:23 AM #2
    zbor
    zbor is offline
    Forum Moderator zbor's Avatar
    Join Date
    02-10-2009
    Location
    Croatia
    MS-Off Ver
    365 ProPlus
    Posts
    15,602

    Re: How to separate cell values by copy/paste them into respective worksheet

    Create Pivot table
    In Report Filter add R column
    and then under Options choose: Show Report Filter Pages
    that will split them among sheet with names of the values (America , India , Canada , Japan)
    Reply With QuoteRegister To Reply
  3. 07-28-2015, 04:37 AM #3
    fluffyvampirekitten
    fluffyvampirekitten is offline
    Registered User
    Join Date
    07-01-2015
    Location
    Singapore
    MS-Off Ver
    2013
    Posts
    66

    Re: How to separate cell values by copy/paste them into respective worksheet

    Quote Originally Posted by zbor View Post
    Create Pivot table
    In Report Filter add R column
    and then under Options choose: Show Report Filter Pages
    that will split them among sheet with names of the values (America , India , Canada , Japan)
    -Create Pivot table (What are the pivot fields?)
    -Where is Report Filter T^T
    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. Copy and paste parts of 600+ separate worksheets into one worksheet
    By snuffnchess in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-22-2015, 11:05 PM
  2. Macro to Copy and Paste Rows from Master Worksheet to Separate Spreadsheets
    By ExcelDummyMK in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-17-2015, 10:54 AM
  3. VBA Match Cell Range to Worksheet Name and copy/paste to respective worksheet
    By rlsublime in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-24-2014, 04:06 PM
  4. Separate a column into sections and copy and paste each section into a new worksheet
    By d23qnq in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-31-2013, 08:21 AM
  5. [SOLVED] Automatically copy and paste (or update) cell values to another worksheet using VBA code
    By jjin in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 01-21-2013, 04:56 AM
  6. Macro to paste values to rows in separate worksheet according to unique identifier
    By mantie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-07-2011, 08:24 PM
  7. Copy and Paste (Same worksheet) based on cell values
    By muckem333 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2011, 04:43 PM

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