+ Reply to Thread
Results 1 to 1 of 1

HELP Copy row into next available row in other worksheet if column "D" matches sheet name

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Question HELP Copy row into next available row in other worksheet if column "D" matches sheet name


    I need to copy the row in sheet 1 into the corresponding worksheet if column D has specific data in it. so when i add another row i would like that to be copied into the correct worksheet and also stay in Sheet 1.

    Example: If i add another row with the word "Excavator" in column D on Sheet 1, i would like every cell with data in that row to be copied into the next available row in the sheet named "Excavators" automatically. There is also going to be around 10-15 worksheets with different names. I would also like the row to be hidden or deleted in the corresponding sheet if that row is hidden in the main sheet (Sheet 1)

    I have never used any Macros or VBA.
    Last edited by kiefermac92; 03-28-2014 at 05:08 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. Replies: 3
    Last Post: 06-22-2013, 12:54 PM
  2. Replies: 7
    Last Post: 04-11-2013, 12:46 AM
  3. Replies: 3
    Last Post: 08-15-2012, 04:00 AM
  4. [SOLVED] Match second sheet column "F" with First sheet column "M" & copy column "C" value
    By johncena in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-09-2012, 11:44 AM
  5. Need to copy text from full "A" column to "A" column on new sheet....
    By Stonesifer in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-15-2011, 02:50 PM


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