Hi,
I am a newbie to excel macro. I need to write a macro for finding unique values between columns A,B,C. That means I need maco to write values which are unique in these three columns to column D.
Can any one help me in this...
Thanks a million.
Hi,
I am a newbie to excel macro. I need to write a macro for finding unique values between columns A,B,C. That means I need maco to write values which are unique in these three columns to column D.
Can any one help me in this...
Thanks a million.
Here is wer I've reached....
Please Login or Register to view this content.
cn anybody tel me is it right or wrong...?
Last edited by royUK; 05-21-2009 at 06:49 AM. Reason: add code tags
If it works it is right, if it doesn't it is wrong.
What is definitly wrong is you need to wrap your code in Code Tags.
Edit your post, click 'Go Advanced', select your code, and then click the [#] button above the edit area.
If you find the response helpful please click the scales in the blue bar above and rate it
If you don't like the response, don't bother with the scales, they are not for you
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thanks for the tags prompt.
Agreed if it works it's right - RahulRaman check your code
However, code can often work but be written to work more efficiently. I would automate AdvancedFilter -> Unique Values & copy to the required column..
Attach a workbook with example data for further help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks