Attachment 147609Hi..
I'd like to make an adjustment in the code below.
How can I use this code, made by my friend Jaslake, to use it with three criteria?
I need to fetch the data sheet of "origin", using the three criteria that are in cell "A2, B2, C2" worksheet "Destination", and play the result in "A6" worksheet "Destination".
Please Login or Register to view this content.
Last edited by Vaibhav; 04-14-2012 at 09:47 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Try
Please Login or Register to view this content.
Thanks but I need to be with the event Private Sub Worksheet_Change (ByVal Target As Range).
Can you do?
Hum... You can just copy and paste the code to the event module? We are free consultant, we can't always do everything. Just saying.
I still believe that anyone can do, the jalaske could, maybe he can help me.
Thanks anyway!
Hi marreco
JieJenn has posted the obvious solution that apparently doesn't do as you require...so. I need to look at it further. The question is, what fires the code. In the code you posted (code you attributed to me so I presume I wrote it) it fires on a change in ANY of these cells "$A$2 $B$2 $C$2"...so, if that's the case I'd assume it can be adapted...but I'll need to think about it a bit. Get back to you.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
yes, exactly these cells is that fire!
I thought it was just change this part, but did not work.
Thank you!Please Login or Register to view this content.
Hi marreco
Yes, well it doesn't quite work that way as you've discovered. As JieJenn suggested, you need to use Advanced Filter. I'll look at it.
My friend told me this amazing website today called Google, you should check it out marreco
Before I could not post my original file.
I tested your code JieJenn, and is not working.
I edited my attachment, try using your code with this spreadsheet for the 1st post.
Last edited by marreco; 03-28-2012 at 07:50 AM.
Have a look at your cross-post
The Code Cage - Filters with three criteria in semi-ready code
If you need any more information, please feel free to ask.
However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....
Also
اس کی مدد کرتا ہے اگر
شکریہ کہنے کے لئے سٹار کلک کریں
If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.
Thank you ...
but I'll try your tip. data is not appearing in the spreadsheet "Destination".
Why?
Hi.
Solved thanks to Donal and Marcol, thanks to all
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks