Hello it's my first time so sorry for any mistake.
I tried make macro which will compare to columns, one in one worksheet second in another. Of corse it sholud make it automaticly becouse i need compare about 2500 cells. Works fie but when I use "x" and "y" in IF formule I cant see masbox which sholud apper. When I put values for example x=5 it work. Why doesn't work with variables.
I make something like that :
Please Login or Register to view this content.
If this is a one off exercise, you might be better using the COUNTIF function. If you use a formula like
pasted into B1 in your second sheet, it will tell you how many times the value in A1 in the second sheet appears in the first sheet. If you get a zero then it isn't there.Please Login or Register to view this content.
I've assumed that the columns of interest are Column A in both sheets for the example above.
Hi lenovomaniac
Your code seems to work fine for me (after removing the comment out from Worksheets(1).Activate). I've attached the workbook I used to run a test on your code. It throwswhen it finds a match from sheet 2 column A in sheet 1 column L.Please Login or Register to view this content.
It appears from your code that this is what you are looking for. If not, explain further what you're trying to do and perhaps I can help.
John
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.
There are many ways to do this, and many ways faster than the one below. The significant changes are (1) eliminating Selecting scells, and (2)move the data capture from the first worksheet outside the inner loop, eliminating duplication.
Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks