LinkBack URL
About LinkBacks
I am trying to find a macro that will identify the unique values of column A in two seperate files and then place those unique values in a third file. Any ideas?
I am trying to find a macro that will identify the unique values of column A in two seperate files and then place those unique values in a third file. Any ideas?
You can record that yourself.
1) Turn on the macro recorder
2) open first file
3) Use the Data > Filter > Advanced Filter to filter that column for UNIQUE VALUES
4) Copy all the visible cells and paste in your 3rd file
5) Close first file without saving any changes
6) Repeat 2-5 with second file
7) Turn off the macro recorder.
_________________
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
Register To Reply
Bookmarks