+ Reply to Thread
Results 1 to 1 of 1

Copy and Past Entire Row based off of Criteria into new Worksheet

  1. #1
    Registered User
    Join Date
    10-25-2013
    Location
    Conway, Arkansas
    MS-Off Ver
    Excel 2010
    Posts
    13

    Talking Copy and Past Entire Row based off of Criteria into new Worksheet

    I am currently creating a workbook that has 5 worksheets. I have a MAINPAGE, where I would like to input all necessary information. Then, based of the criteria in Column H, paste the entire row into the according worksheet. For example, if Row1=Scrap, Copy entire row to Scrap worksheet.

    I am not familiar with VBA or macros. Was hoping for a formula, but if one is not available, with a little explanation of macro code I can understand. Any help would be appreciated!
    Attached Files Attached Files
    Last edited by KLiving; 10-25-2013 at 11:10 AM.

+ 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. Copy entire row based on a criteria - using macro
    By scambug in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-23-2013, 02:37 AM
  2. copy/past rows based on a value in a new worksheet
    By Wacky in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2013, 10:37 AM
  3. Linking data based on a cell value and copy/past to another worksheet??
    By Tweech in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2012, 01:12 PM
  4. copy and past to different sheets based on criteria
    By rz6657 in forum Excel General
    Replies: 4
    Last Post: 10-05-2010, 11:56 AM
  5. [SOLVED] Copy entire row to another sheet based on a criteria
    By Brig Siton in forum Excel General
    Replies: 3
    Last Post: 08-07-2006, 04: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