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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By kathyp in forum Excel Formulas & Functions
Last Post: 06-22-2013, 12:54 PM
By bkwins in forum Excel Formulas & Functions
Last Post: 04-11-2013, 12:46 AM
By ismegordo in forum Excel Programming / VBA / Macros
Last Post: 08-15-2012, 04:00 AM
By johncena in forum Excel Programming / VBA / Macros
Last Post: 04-09-2012, 11:44 AM
By Stonesifer in forum Excel - New Users/Basics
Last Post: 02-15-2011, 02:50 PM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1