Copy with Criteria

[rizmomin]

Hello:

I have lots of bank transaction data in column A thru F.

I need to copy all row's of data if value of Cell in Column E consist of text "Loan to" and corresponding cell in column F is
negative.

I have manually pasted data in Cell J2.

Please let me know if any questions.

Thank you

Riz Momin

[MarvinP]

Hi Riz,

Find the answer to your question here:
http://www.contextures.com/xladvfilter01.html

Didn't I do an advanced filter for you a few days ago? I don't want to do this one for you as I think you can figure it out yourself...

If you first try and can't make it work, bump this and we can see what the problem is...

[AB33]

Riz,
Try the attached

[rizmomin]

Hi AB33:

This works great for me.
I am very thankful for all exceller on this forum for great help.
I am not a VB programmer and all helps are greatly appreciated.

Thank you

Riz Momin

[AB33]

Riz,
You are welcome!

[rizmomin]

Hi AB33:

I have changed "[Loan to *]" to "Income *" to see if it filters but it gave error.
Can you please have a look and let me know.
I want to make this code so that i can filter any category
Thank you

Riz Momin

[AB33]

Riz,
Please find amended.
If the filter does not find criteria true, it does not copy anything. To test it, I have changed the income row in to negative, and the code copied that row.

[rizmomin]

Hi AB33:

Yes this works, thanks a lot..

Riz Momin

[rizmomin]

Hi AB33:

I am moving down the data to start from row 4 instead of row 1.
By doing that it gives error.
I change the code

Please Login or Register  to view this content.

But gives error.
Can you please have a look and see where i am going wrong.

Thank you

Riz Momin