+ Reply to Thread
Results 1 to 5 of 5

Copying row from one worksheet to another if a specific cell matches

  1. #1
    Registered User
    Join Date
    08-07-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2007
    Posts
    3

    Copying row from one worksheet to another if a specific cell matches

    I have never written a macro in excel before. I am trying to organize my PTAs spirit wear orders for ease of placing the order. I have entered all orders into a master worksheet titled "spirit wear". I have separate tabs created for each size we are selling (22 different options). I would like the macro to search the master worksheet and copy the rows that correspond to the correct size.

    For example, I would like all of the orders for L GC (large grey child) to be copied to a tab title L GC.

    If anyone can help me, it would be greatly appreciated!
    spreadsheet.jpg

  2. #2
    Registered User
    Join Date
    08-07-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Copying row from one worksheet to another if a specific cell matches

    this is the file I am working with
    Attached Files Attached Files

  3. #3
    Forum Expert
    Join Date
    07-31-2010
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    4,070

    Re: Copying row from one worksheet to another if a specific cell matches

    How about this:

    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Copying row from one worksheet to another if a specific cell matches

    stnkynts,
    It works, but you are missing the heading (Row1) in all sheets.

  5. #5
    Registered User
    Join Date
    08-07-2013
    Location
    Indianapolis, IN
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Copying row from one worksheet to another if a specific cell matches

    Thank you thank you thank you!!! This is a huge time saver for me!!

+ 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: 9
    Last Post: 12-30-2013, 11:35 AM
  2. Replies: 2
    Last Post: 08-05-2013, 07:32 PM
  3. [SOLVED] Remove first character of cell if it matches a specific value
    By magus474 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-01-2013, 05:24 PM
  4. Creating, copying and renaming new worksheet based on specific cell contents
    By johnejo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-26-2012, 01:16 PM
  5. Copying specific cell ranges from a worksheet multiple times to a new sheet
    By kaz8772 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-10-2009, 03:54 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