Hello all
This is my very first post to this forum and I must say I’m very happy to have found this site, I hope you guys can help me out.
My problem is the following.
I have an excel sheet with more than 57000 rows and 7 columns.
Some of the rows are highlighted and some are not.
First column contains first and last names and 2nd columns contain Social Security Numbers.
I want to move all duplicate names plus social security numbers that are highlighted from the non-highlighted ones to another sheet.
You can sort the data alphabetically.
In other word, if I find a row that is highlighted and name and social security number in that row matches another non-highlighted row, move the highlighted row to another sheet.
All the rows have names but some of them are missing social security numbers. If you find and empty social security numbers cell, jump over that row.
I have been working on this one off and on all day today and I have a deadline at 2:00 pm tomorrow.
So please if any of you gurus out there can help me out, I’ll be tank full for years to come :)
I will include an example file.
Thanks for your time and any help
PS: a Macro would be the best way to go for me.
Regards, Mel Shad
Bookmarks