FORMULA HELP ! !

  • Thread starter Thread starter GA85
  • Start date Start date
G

GA85

I need a formula to do the following:

If in column 3, a cell says "cash", I need that entire row that contains
"cash" in column 3 to be transferred to another worksheet.

PLEASE HELP!!
 
If you apply autofilter to that column and select "cash" from the
filter pull-down, you will see only those records. Then highlight the
visible records and copy/paste them to the new sheet - only the
filtered records will be copied.

Hope this helps.

Pete
 

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

hidden rows problem 7
putting number against certain words formula 0
FORMULA HELP ! ! ! 1
Copy Data from One Spreadsheet to Another ?????? 5
Excel VBA 1
Running Total, Opening & Closing Acct Balance in Cash Book 1
Cash Flows Inflation Adjusted 2
Working with arrays as arguments 6

Back
Top