+ Reply to Thread
Results 1 to 5 of 5

Copy data to another sheet based on a colum value

  1. #1
    Registered User
    Join Date
    03-11-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    5

    Copy data to another sheet based on a colum value

    Hello all.
    I am trying to get a macro or VB script to run where as it looks at the values in colum G. Based on these values, it creates a new sheet with the name of a colum G value and moves the rows that have the value into the sheet of the same name. In effect, I am trying to seperate the catagories so it is then easier for me to filter and report the results.
    Make sense?
    I have uploaded a sample of my sheet as a reference.
    Attached Files Attached Files

  2. #2
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Copy data to another sheet based on a colum value

    Try the attached solution
    Attached Files Attached Files
    If you like my contribution click the star icon!

  3. #3
    Registered User
    Join Date
    03-11-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    5

    Re: Copy data to another sheet based on a colum value

    It worked
    One thing it did do was delete the data from the master sheet (Sheet1). Is there anyway to preserve this information in Sheet1 as I might need to come back to that sheet to provide an overall view of that data.
    Last edited by Abeniston; 03-15-2013 at 12:49 AM. Reason: It now worked :)

  4. #4
    Forum Expert OllieB's Avatar
    Join Date
    12-20-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007 (home) & 2010 (office)
    Posts
    1,542

    Re: Copy data to another sheet based on a colum value

    You specified move so I moved as opposed to copied. Remove the Rows.Delete instruction in the loop to keep the rows on the master worksheet

  5. #5
    Registered User
    Join Date
    03-11-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    5

    Re: Copy data to another sheet based on a colum value

    Cool. Thanks for all your 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