Can somebody help me how to find the Duplicate Column Headers in entire workbook. i have a workbook which has multiple sheets and i need to validate none of the sheet shouldn't have a same column present in other sheets or same sheet.
Thanks in Advance..
Last edited by sandeepgoud88; 03-26-2019 at 12:44 PM.
How many sheets? If it's just a few, then, copying a pasting the headers into a new tab and using a series of MATCH() or HLOOKUP() functions should do the trick. If there are a lot of tabs, then it might be be better suited for VBA.
Hi, how's your vba knowledge? Do you have any experience with macros? I think that would be the quickest way
Before even attempting to explain you need to give use here enough information to work on.
You have not told us if all the column headers are on the same row as the other worksheets.
Is there one worksheet that serves as a master sheet or doesn't that matter? You can also have a macro trigger every time a column header is changed to check if it already is present and then warn the user and reset the old value.
Don't let the person with the intention to help you base his/her answers on assumptions.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
This macro will highlight each duplicate header assuming that the headers are in row 1 of all the sheets. It does not highlight the first occurrence of the header, only all the subsequent ones if found.
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Thank you this works perfect...
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks