+ Reply to Thread
Results 1 to 3 of 3

How to send matching column to new worksheet

  1. #1
    Registered User
    Join Date
    10-23-2012
    Location
    Oklahoma
    MS-Off Ver
    Excel 2010
    Posts
    2

    How to send matching column to new worksheet

    I am trying to create a directory database for a church to help group people by certain criteria. I'm struggling to figure out how to make an if statement that will say if column B equals this criteria (like a number 1 for group one), move the entire row to worksheet 1. I need to do it for 14 groups. Any ideas on how I could do this?? I have a feeling the answer is very basic and I'll feel dumb, but I'm asking anyways! :0)

  2. #2
    Forum Contributor bonny24tycoon's Avatar
    Join Date
    04-02-2012
    Location
    Hell
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    405

    Re: How to send matching column to new worksheet

    Can you upload an example workbook??

  3. #3
    Registered User
    Join Date
    10-23-2012
    Location
    Oklahoma
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: How to send matching column to new worksheet

    Sure, here is what I am trying to do.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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