Auto Copy/autofill Text from sheet to sheet if meets criteria

Joyce

Guest

Posts: n/a

20th Nov 2008

Hello! Using Excel 2007

I want to automatically take text from one worksheet and display it on a
different worksheet if it meets a text criteria. IE, if the DEPARTMENT
column value is "finance" - then display the whole row of data in the new
worksheet. If it does not meet this criterion - then return nothing (but I
do not want empty rows).

I appreciate any assistance! Thanks!

« Printing UserForms | Save Pivot Table Format in 2007 »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto copy cell data from source sheet to another wrkbook sheet	IVLUTA	Microsoft Excel Programming	2	2nd Jun 2009 05:07 PM
Copy from sheet to sheet when matches criteria	jeremiah	Microsoft Excel Worksheet Functions	2	2nd Jun 2009 01:05 PM
Help: auto-copy entire rows from 1 sheet (based on cell criteria) to another sheet.	bertbarndoor	Microsoft Excel Programming	4	5th Oct 2007 04:00 PM
copy row to new sheet where cell value meets criteria	=?Utf-8?B?ZGpoczYz?=	Microsoft Excel Misc	1	13th Feb 2007 03:04 PM
Array to read data from one sheet and write to another if it meets criteria	RudyShoe	Microsoft Excel Programming	2	2nd Aug 2006 04:38 PM