EXCEL VBA: FILTER DATA then COMPARE DATA
I have two spreadsheets, named Sheet1 and Sheet2 which has the SAME Columns but different DATA INPUTS. What I want to do is FILTER data in the SHEET1 and SHEET2 and after filtering COMPARE the data's that are FILTERED.
But what's happening to my code, even after filtering it still compares the unfiltered data.
Can you help me to work this out?
Here's my code for COMPARING.
Please Login or Register to view this content.
Here's my code for FILTERING.
Please Login or Register to view this content.
One suggestion
- copy the filtered data to sheets "Filtered1" and "Filtered2"
and:
Please Login or Register to view this content.
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Perhaps something like this....
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Thank you for the suggestion, trying it now! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks