+ Reply to Thread
Results 1 to 3 of 3

Copy entire row from Master sheet based on two criteria

  1. #1
    Registered User
    Join Date
    10-03-2011
    Location
    Decatur, IL
    MS-Off Ver
    Excel 2003
    Posts
    3

    Copy entire row from Master sheet based on two criteria

    Hello!

    I need help copying and entire row based on two criteria. I have a master sheet named "WC". I have 7 additional sheets named for their criteria.

    I've been trying to write a formula that will search column N for a range of numbers and specific word in column O then copy the entire row into the new sheet if both conditions exist. For example, 25,000 to 99,999 from column N and 'Base' from column O.

    From what I've seen the fastest way to do this is to use VBA; however, I have limited experience and was hoping someone could point me in the right direction. I've attached an example workbook.

    Thank you in advance!
    Attached Files Attached Files

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Copy entire row from Master sheet based on two criteria

    =SUMIF(#REF!, $C5, (#REF!)) in column n
    and its not very clear what you are looking for where all the other sheets are blank except column headers
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Valued Forum Contributor tehneXus's Avatar
    Join Date
    04-12-2013
    Location
    Hamburg, Germany
    MS-Off Ver
    Work: MS-Office 2010 32bit @ Win8 32bit / Home: MS-Office 2016 32bit @ Win10 64bit
    Posts
    944

    Re: Copy entire row from Master sheet based on two criteria

    Hi,

    please check the attachment: Working Copy ss.xlsm

    You have to define the worksheet names ans assign criteria to it manually in the code, actually only 1 row was copied..

    code:
    Please Login or Register  to view this content.
    Please use [CODE]-TAGS
    When your problem is solved mark the thread SOLVED
    If an answer has helped you please click to give reputation
    Read the FORUM RULES

+ 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