+ Reply to Thread
Results 1 to 1 of 1

Excel 2011 macro to move rows from one sheet to another and group based on criteria

  1. #1
    Registered User
    Join Date
    08-06-2013
    Location
    Blue Bell, PA
    MS-Off Ver
    Excel 2011
    Posts
    1

    Excel 2011 macro to move rows from one sheet to another and group based on criteria

    I've been reading through the forums trying to find an answer but the sample code I've found doesn't work. Basically, I have a sheet of data with three columns for Page Name and then two metrics.

    I need a macro that will let me pull different criteria (i.e.- Hockey and Football) and then move it to the second sheet into a group (i.e.- Group A). If there's a way to set up the macro so that I can do all of the groups at once that would be ideal. I read a post here (post #6) about using an array but copying that code gives me a compiling error: "named argument already specified" and when I go back to the macro the sub is yellow and the number 1 in field:=1 is blue.

    I'm not familiar with macros or vba. I'm trying to learn as I'm going so ANY help is greatly appreciated. I've attached a sample workbook related to my description above. Thanks so much!

    Sample WKBK.xlsx
    Last edited by jasond02; 08-09-2013 at 03:26 PM.

+ 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. Replies: 12
    Last Post: 02-21-2013, 12:55 PM
  2. Move Rows of Data from a Specific Column (Based on Matching Criteria) to a new Sheet
    By jordan1214 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2013, 02:30 AM
  3. Macro to move rows from one sheet to another sheet based on a cell vaule
    By d55272 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-09-2012, 03:33 PM
  4. How to select a group of shapes and textboxes with a vba macro in excel Mac 2011?
    By eratosthene in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-03-2012, 10:19 PM
  5. Macro to move rows, row by row, based upon specific criteria.
    By luke8182 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-20-2012, 01:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1