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

J

Joyce

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top 5 list if data meets a criteria 3
Counting data from sheet to sheet 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
copy rows from one Data sheet to another sheet based on cell conte 2
Auto Copy Data from one worksheet to another 1
copying whole row to another sheet based on criteria on cell 0
Autofill data from one tab to another under certain criteria 3
summing across worksheets conditionally and being able to copy for 4

Top