Hello,
I got the solution from this forum to remove duplicate in child sheet if the records for columns A, H and S are exactly matching with the columns A, H and S of Master sheet.
When I used it in some of my other process, it is not working. can anyone help me.
Advance thanks
Please Login or Register to view this content.
in your attached file ther'is in A1 the word ResponsibilityPlease Login or Register to view this content.
If solved remember to mark Thread as solved
Also, your formulas being inserted are actually checking columns B, H and S, not A, H and S. RC2 means column 2.
_________________
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!)
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks