Hi All,
I have a list of households (sheet 1) from which I have selected around 10% into sheet 2. I would like to create a third sheet that includes all the numbers not selected into the second sheet. I will send the file as soon as I hear from anyone especially that I am not able to attach anything right now.
Regards,
Afamia
I would suggest adding a column with this formula in sheet1, starting in row 2:
=IF(ISNUMBER(MATCH(A2, Sheet2!A:A, 0)), "Used", "Unused")
Then you can run an AutoFilter on that column for the word "Unused" and copy all the values left visible to Sheet3.
You should be able to code that into a macro without too much difficulty. You can use my Skype link (up to the right) to send me a file if you have trouble with that.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks