Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel Script Re-Write?

Status
Not open for further replies.

archwayguy

Technical User
Oct 30, 2008
58
US
I'm not a pro in programming in the least bit, in fact, I know nothing about it. I have a script I found on the net that will take two columns in Excel and filter all duplicates to only show unique cells in either column. Now I need something that will do the exact opposite but with multiple columns. I need this to tell me what is a duplicate in more than one column. The script I currently have is ran by just drag-and-drop the Excel file onto the .vbs and then it creates a new sheet in the Excel workbook. It can be found here: Any helpers that can tell me how to fix this to my liking or could do so for me? Here is another link I found for conditional formatting that does what I am looking for, but is there an easier way to do this?
 
Hi,

This is a job for Forum68, I beleive. Please repost your thread in Forum68.

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
lol. Last time I asked something of this nature in the Office side, they sent me here. That's ok though, I managed a way around it just using a formula. In case anyone needed to know, I just condensed everything into two columns of new data and old data. Then inserted the info found here:
 
archwayguy,

For future reference; they didn't send you here, they sent you to the VBA forum, forum707. It can be confusing ;-)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top