Over 1 million tech questions and answers.

Want to delete duplicate cells in a row, row by row, going down the sheet.

Q: Want to delete duplicate cells in a row, row by row, going down the sheet.

I have rows of data with duplicate cells in each row.

I do not want to delete any rows.

I want to delete only duplicate cells in each row.

There are many ways to delete dups in columns. I do not want to delete rows. I do not want to delete rows if dups appear in the row. I want to delete the dups going across the sheet from left to right, row by row, going down the sheet from top to bottom.

For example, I five rows...

fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep
fox, sheep, goat, fox, dog bone, cat, fox, sheep

I want to delete the duplicate cells in each row. I want to end up with the following...

fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat
fox, sheep, goat, dog bone, cat

Just to clarify, if a cell is repeated in a row, one unique cell should be left in the row in which the repeated cell appears. I only want to delete repeated cells in the rows in which the repeated terms appear, leaving only one unique where the repeated cells appear. If the word "cat" appears five times in row 2 and three times in row 3, after the macro is run, the word "cat" should appear once in row 2 and once in row 3.

In some cells, spaces do appear because in some cells, the cells contain a short phrase (dog bone) rather than just one word. If two or more cells contain a phrase, after running the macro in each row, only one cell should contain the phrase in each row.

Thank you in advance for any replies.

RELEVANCY SCORE 200
Preferred Solution: Want to delete duplicate cells in a row, row by row, going down the sheet.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Want to delete duplicate cells in a row, row by row, going down the sheet.

Read other 11 answers
RELEVANCY SCORE 81.6

Does anyone have a macro that will delete row that have duplicate cells in same row other columns?

A:Excel Macro to delete row with duplicate cells

Hi

Are you looking to delete rows that have duplicate data but the duplicate data is in different columns?
Can you give a small example?

If the duplicate values are in the same column then you can use the 'remove duplicates' tool.
Select the rows/columns then go to DATA and you should see the REMOVE DUPLICATES tool.

James

Read other 5 answers
RELEVANCY SCORE 80.4

Simple problem - copy sheet then delete duplicate rows

I have a worksheet that is composed a header row, and columns of data (client call results).
Each client is identified by a unique ID number in column A, a seperate column F has the 'call number, from 1 to x'.
So a client can have a single or multiple rows of data. Each client group of rows is sequenced with call 1 as line 1, call 2 at line 2, etc. etc. as your proceed down the rows.
The entire worksheet is already sorted (with a header row) ascending by client id and call #

What I want to accomplish is this

1 - copy the existing worksheet (CallRecords) to a new worksheet (CallToday)
2 - in the new worksheet, scan down (or up) from first data row (2) to the last row {ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row} and
delete duplicate rows of the Client ID retaining the row with the max call number for that client id.
3 - sort the new worksheet (CallToday) ascending by column (G) date, and column (H) time.

Thanks for your help. I am a newbie to VBA.
 

A:Simple problem - copy sheet then delete duplicate rows

stewartrr said:

I am a newbie to VBA.Click to expand...

Not a problem, since you don't need it for this ; a combination of built-in functions will do.

It's not clear if you have blanks in col A -- if you do, that can be easily fixed.

See the attached. The list of ID #s in col A of Sheet2 was extracted from Sheet1 using Advanced Filter (unique records only). The formulas in col B of Sheet2 pull in the value from col B of Sheet1 (per the last row for each ID #).

Post back if you need help interpreting the formulas.
 

Read other 1 answers
RELEVANCY SCORE 65.6

Okay I have one main worksheet named "A" I insert rows into this sheet and Depending on what is is Col B I want info copied to another Sheet based upon what is put into Col B.

Col B can contain "Army", "Navy","Marines"

If I enter Army into Col B, then Copy that selected Row, Col: A, B, C, E,J into worksheet Named "Army" into first unused Row in Col A,B,C,D,E.
 

A:Solved: Copy Certain Cells from a Row to a certain Sheet..

Read other 16 answers
RELEVANCY SCORE 65.6

I'm trying to delete the first 5 rows of every sheet except Sheet 1, and delete the last row of every sheet except sheet 1 (sheets are different lengths).
Can anyone steer me in the right direction? I've tried google searching for scripts that might work but when I piece them together I get errors everywhere.

Frankenstein code I pieced together:

Code:

Sub DelRows()

Dim Wks As Worksheet

For Each Wks In Worksheets
If LCase(Wks.Name) <> "Sheet1" Then
CurrentSheet.Range("a1:a5").EntireRow.Delete
End If
Next Wks

End Sub
 

A:Solved: Delete top 5 rows from every sheet except for Sheet 1

xmmx,
Try this.
Code:

Sub Delete_5Rows()
Dim wsheet As Worksheet
Dim wb As Workbook
Set wb = ActiveWorkbook
For Each wsheet In wb.Worksheets
With wsheet
If wsheet.Name <> "Sheet1" Then
wsheet.Activate
With ActiveSheet
wsheet.Range("a1:a5").EntireRow.Delete
wsheet.Range("A65536").End(xlUp).EntireRow.Delete
End With
End If
End With
Next

End Sub
 

Read other 3 answers
RELEVANCY SCORE 64

Hello,

I have a huge data sheet with customer info. I want to input a customer number in Sheet2 Cell A2. I have another Sheet names "Boat" which has all of the data. I want to search for the number inputted in Sheet2 Cell A2 and for each time it is found in the other sheet "Boat", I want to copy the entire row of data and paste in Sheet2 Cell H5 and repeat untill the inputted number isn't found again in "Boat". I currently have a vlookup that is pulling each column of data, but I need a way to make it loop until the input number isn't found. Items in "Boat" sheet are not sorted in anyway as of now. I am new to VBA, so any suggestions would be great.
 

A:Solved: Copy row of cells to another sheet or loop a vlookup

Read other 16 answers
RELEVANCY SCORE 64

I widened some cells in sheet1. I highlighted the cells I wanted to be pasted onto sheet2, but the cells became the default size (before I widened them in sheet1). How do I copy and paste EXACTLY the SAME appearance meaning the size of the cells from sheet1 to sheet 2?

Thanks
 

A:Solved: copy and paste cells from one sheet to another with exactly same outlook

Read other 6 answers
RELEVANCY SCORE 64

Hey

Please see the attachment which will hopefully make this easier to explain.

What I need to do is;

* In the 'All Orders' Sheet if Column E (Supplier) Matches the text in 'Wolds' A2, then copy that row of data from 'All Orders' to the 'Wolds Sheet'

* I need to make sure that the data from previous runs that has been copied across does not get duplicate (But sill remains in the list)

* I need the headings in 'Wolds' to remain (So data to start in row 3)

* Also in column P in 'Wolds' (Code) I need that column to remain untouched, and numbered as it is (W1 W2 W3 etc)
Thank you
(I've also asked this question here; http://www.ozgrid.com/forum/showthread.php?t=189975&goto=newpost**

&

here; http://www.mrexcel.com/forum/excel-...-row-data-if-two-cells-match.html#post3885898)
 

A:Copy cells from 1 sheet to another is column equals certain text

Already seems to be taken care of on both other forums
 

Read other 2 answers
RELEVANCY SCORE 63.6

My spreadsheet has Locked and Unlocked cells and when I Protect the sheet, the only thing I can do is enter data into the Unlocked cells. It does not allow me to format the cell, ie: Bolding orr changing alignment, etc. In Word 2003, I could do this as well as use the AutoSum feature. Am I doing something wrong? I cannot find any answers on the internet or Help screens. Any input is much appreciated.
 

Read other answers
RELEVANCY SCORE 62.4

hello to one and all,

I have a an Excel spreadsheet (2010 windows 7) which has a large amount of data. I know that potentially up to 1/3 of this data is duplicated. I can use the "remove duplicates" button to clean the data but i need to be able to see which entries had been duplicated. Is there any way to be able to see which data is removed during the clean up?

thanks for any advice
 

A:Solved: duplicate cells

Read other 12 answers
RELEVANCY SCORE 60.8

So I'm trying to find computers that list multiples of the same or similar software in Active Directory. I have everything in a spreadsheet as below. [No, I don't have better access to AD]. Sometimes the software instance is exactly the same, sometimes it's just a word in the instance that's the same.


Code:
WorkstationID Software
DDCHLK085887 3_FUJITSU_FI5015C_WN7 3_FUJITSU_FI5015C_WN7
DDCHLK087033 O_ACROBATPRO_11010_WIN 3_AUTOCADNOLIC_2012_AXP 3_MSPROJECTSTD_2010_WN7
DDCHLK088174 O_ACROBATPRO_11010_WIN 3_MSPROJECTSTD_2010_WN7
WDCHLK088317 3_ATTGNC_9210_AXP_GFE_23 3_ATTGNC_9210_AXP_GFE_23 3_ATTGNC_8110_A_AXP_GFE_23
DDCHLK089478 3_PROJECTPRO_2010_WN7 3_MSPROJECTSTD_2010_WN7
WDCHLK089659 O_ACROBATPRO_11010_WIN
Row 5 has three versions of ATTGNC, two of which are the same.
Row 6 has two versions of project.

What I'd like is for the duplicate software to be highlighted, or maybe a cell that says 'DUPLICATE!" or something. I can find exact duplicates, but what I can't figure out is how to discern between, for example 3_ATTGNC_8110_A_AXP_GFE_23 and 3_ATTGNC_9210_AXP_GFE_23. Any help is greatly appreciated. I've got several hundred computers to check and doing it by hand sucks!

Read other answers
RELEVANCY SCORE 60.8

Hi all

Is there a way (using functions/formulas) to have Excel automatically duplicate the contents of a row on one sheet onto another sheet within the same workbook if text in one column of the first sheet contains a certain word? And if so, how could this be achieved?

I have attached an example workbook to help explain what I'm trying to achieve.

What I want to end up with is when I type text in any row of the Master sheet, I would like the entire contents of each row to automatically be repeated on the worksheet of the same name (as per column O). For example row 5's contents from the Master sheet would duplicate into the sheet named Accommodation. In addition, should the details ever change in the Master, this would need to be reflected in the individual sheets also. My only concern is that I'd like the individual sheets to fill from the top rather than match the exact row number position from the Master, ie row 5's contents to be placed into row 2 of the Accommodation sheet seeing as it's the first occurrence, and row 6's would go into row 3 etc.

I hope that all makes sense, please let me know if not.

I'd be hugely grateful for any suggestions & help. Thanks heaps.

Sue
 

A:Solved: Excel: Auto duplicate row contents from 1 sheet to another if col contains a

Read other 11 answers
RELEVANCY SCORE 60.4

I have an Excel (2007, running XP Pro) with 5 worksheets. When I type data in one cell, it sometimes duplicates the data in other worksheets. I think that when it does this, the file name at the top of the screen is followed by [group]. What might this be about please, and how do I stop it happening?
 

A:Solved: Excel: cells duplicate content in other tabs

If all tabs are selected, just click on any tab other than the current one and select back you tab.
If only selected tabs are selected, click on any tab outside the highlight group and then click back.
 

Read other 1 answers
RELEVANCY SCORE 53.6

I am a newbie to Excel and have created a small calculation worksheet.
It only occupies a small section of the worksheet and I would like to know how to only show that part and not showing the empty cells.
I am using Microsoft Office 2007.

Thanks
jack

A:Delete empty cells in worksheet

  
Quote: Originally Posted by jackdash


I am a newbie to Excel and have created a small calculation worksheet.
It only occupies a small section of the worksheet and I would like to know how to only show that part and not showing the empty cells.
I am using Microsoft Office 2007.

Thanks
jack


Check out the following:






Quote:
Question
Hi, I am looking for a solution to hide columns based upon their content.

I know this is logically possible but I am struggling with the "How" and really do hope you can help me.

Background Info: I have a database which holds data from which I am building reports for users. This database has an Excel Add-In which allows me to create reports (views) in Excel to distribute to users. The Add-In has a switch which automatically suppresses any rows which has zero's in the cells across the columns.

Problem: The report I am building uses 219 columns. Most of these columns contain zero's. I would like to build a macro to hide these columns so that the users only see those columns with data in them.

Thank you in advance for your help.

Kind regards,
Reshma

Answer
Hi Reshma,

Here is a macro that will hide zero-filled or empty columns:

Sub HideEmptyColumns()

' This macro hides empty or all-zero columns in the active worksheet
' It ignores columns outside the used range (UsedRange)

Dim Col As Range

For Each Col In ActiveSheet.UsedRange.Columns
Col.EntireColumn... Read more

Read other 1 answers
RELEVANCY SCORE 53.6

I have the following code, but when I run it, I get "Cannot use that command on overlapping selections" and the Selection.EntireRow.Delete line is yellow.

Sub DelBlankRows()

Columns("D").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.EntireRow.Delete

End Sub

There is no Center and Merge on Column D, but there is in Column C. Is that potentially causing this issue?

-Stradt23
 

Read other answers
RELEVANCY SCORE 52.8

I have a worksheet with entries in 12 columns and 200 rows. I have follg issues
1)I tried to select a range of entries, right clicked and tried to "select delete". But curiously Delete as an option (and Cut as an option) is greyed out. Not sure why it happens.But if I try to use Cells toolbar and select Delete--> shift Right it works.
2) I also noticed that whenever I open a workbook the "enable fill handle and drag and drop" feature gets unchecked in The Excel Options menu.
Office Button-->Excel Options-->Advanced Options

Are these because of any add-ins?
 

A:Excel delete a range of cells in a column

Hi, why don't you start by telling us which version of Excel you're using?
And about Add-Ins, have you installed any Add-In? Is so you could start by disablig them one at a time to see if it makes a difference.
 

Read other 3 answers
RELEVANCY SCORE 52.8

I have a list in column A down to row 59325. Many cells are highlighted red. How can I delete all red cells? THANKS!
 

A:Solved: Delete highlighted cells in excel

Read other 13 answers
RELEVANCY SCORE 52.8

Hi there!

I have customer details in Excel and for my business I would like some sort of way where I can have macro/button which on that sheet automatically copies the customer details in that sheet, to another sheet which holds the old customer details. But then deletes it in the customer details sheet.

So a kind of fancy cut and paste! I really need to sort this out, and will be happy for any ideas and suggestions!

Thanks,

Melissa xx
 

A:Help! Automatically copy table in excel to different sheet and then delete!

Hi Melissa

Can you post a sample workbook that reflects the structure of your workbook i.e. the sample file should not contain real names, addresses etc but should have dummy data and contain the same number of columns, column headings sheet names etc. We can then build for you a macro to do what you want.
 

Read other 3 answers
RELEVANCY SCORE 52.8

I started out with the two previous posts about macros (post 1, post 2) that move rows into columns, but I'm having a little trouble getting it to work for what I need. First, I'm trying to do a data merge into Word, but in order to get the data merge to work/look the way I want it to, I need the XLS data to be in columns.

I'm attaching an example file that has one worksheet of the sample data (though my "real" data has about 300 rows) and the other worksheet is an example of the outcome I need.

Is there anyway I can do what I need? Exporting into another file or another worksheet within this file would be fine.

Thanks in advance.
 

A:XLS Macro to move data to columns, delete empty rows, delete duplicate columns

Read other 11 answers
RELEVANCY SCORE 52.4

Hello, Can anyone help me. I need to add a macro that can iterate through a number of worksheets and delete all the data from cells that are unprotected.

I have tried a few things but being unable to find an diagram of the excel object model with properies and fields has slowed me down, if anyone can solve my query and point me to such a document that would be excellent.
 

A:Excel macro, change delete from unprotected cells.

You can use the cells "locked" property to determine if the cell is protected or not.

You can can use VBA to select the cells or you can manually select your range of cells and use a simple loop to take appropriate action. How many workbooks and/or sheets are we talking about running this code on? If you provide more details about your process we can give you more code showing how to loop through each sheet in the workbook or even how to loop through an entire directory of workbooks.

Code:

For each vCell in Selection.Cells
If vCell.Locked then
'Your code here
End If
If Not vCell.Locked then
'Your code here
End If
Next

Rollin
 

Read other 3 answers
RELEVANCY SCORE 51.2
RELEVANCY SCORE 51.2

duplicate - delete
 

A:duplicate-delete

at the top right of your post, click on the Edit button. At the top of the page you will see a check box marked Delete. Check it and then click the Delete Now button!
 

Read other 1 answers
RELEVANCY SCORE 51.2

Been using Glary's Utilities 3 to clean things up. When I ran its "Duplicate" cleaner, there were many duplicates with iTunes and my pictures. My problem is that I don't know which to delete and which to keep. Here are screen shots to give you an idea of what the duplicate scan showed (BTW, there are many other areas where there are a mess of duplicates,but to keep things simple-I hope, I've only shown those duplicates that may take up a lot of space:

A:Which duplicate(s) to delete?

Flycaster mate cannot see any screenshots? so cannot comment.

Personally I am not that overly keen on add on software like Glary but it's your choice.

Read other 2 answers
RELEVANCY SCORE 51.2
RELEVANCY SCORE 50.8

Is there a good free program or way of deleting duplicate music files, simply?

Thanks for any help!

A:Trying to Delete Duplicate MP3 files

right click on the file and choose delete

Read other 4 answers
RELEVANCY SCORE 50.8

Duplicate post, please delete

Read other answers
RELEVANCY SCORE 50.8

Hi, Is there such a program as a free duplicate photo finder out there for download? I have a ton of duplicate photos on my hard drive and need to delete them. Thanks.
 

A:Delete duplicate photos

Read other 9 answers
RELEVANCY SCORE 50.8

Is there a good free program or way of deleting duplicate music files, simply?

Thanks for any help!
 

A:Trying to Delete Duplicate MP3 files

Read other 10 answers
RELEVANCY SCORE 50.8

I am using WLM in W7 x 64 bit on my desktop. Recently several duplicate contacts have appeared in my contacts list.
I have tried to delete them by right clicking on the duplicate contact, but in every case the 'delete contact' is greyed out.

Can you please help ?

A:Delete duplicate contacts in WLM

Hello mate now the first that comes to mind is that you run these if you haven't already
http://www.sevenforums.com/tutorials/1538-sfc-scannow-command-system-file-checker.html
http://www.sevenforums.com/tutorials/433-disk-check.html < if necessary include the /f and /r in the command line as per Option2

if those do not fix the problem then a scan with these - just to eliminate anything untoward that may be lurking
http://www.superantispyware.com/
http://www.malwarebytes.org/products/malwarebytes_free/
http://www.bleepingcomputer.com/download/adwcleaner/
ADW download from bleeping computer delete any rubbish found with the malware scans
(with ADW if you are running Kaspersky it will throw it up as malware just override Kaspersky by ignoring it or disabling it for the duration of the scan)

Read other 1 answers
RELEVANCY SCORE 50.8

Hi there,

I told my buddy I wanted to reformat my computer. He went to do that by installing a new Windows 7 64 bit for me, but somehow, I now am operating on the new Windows 7 but my old Windows 7 still exist and is taking up enough space in my hard drive to annoy me

Can someone please let me know how I can delete the old Windows from my hard drive? I'm having to install all the old applications I used to have (Quickbooks, Photoshop etc) and it's eating up the hard drive space due to double applications.

Thanks for the help!

A:How Do I Delete An Old Duplicate Windows?

Hello Tony, and welcome to Seven Forums.

Sure thing. The tutorial below can help show you how to delete the Windows.old folder.

Windows.old Folder - Delete

Hope this helps,
Shawn

Read other 3 answers
RELEVANCY SCORE 50

Ok another challenge.. I wish I could do this myself, but I struggle with the code.

Is there a way to have a macro check the line below it, and if it is a duplicate row, delete it
 

A:Solved: Im sure it can be done.. Delete Duplicate Rows

Read other 16 answers
RELEVANCY SCORE 50

How can I create a query to delete duplicate records?
 

A:query to delete duplicate records

Read other 9 answers
RELEVANCY SCORE 50

I want to free up space on my hard drive, so I ran a duplicate files finder.
I have several duplicate copies of (large) driver files.  I would think that I only need one.  One of the folders with drivers is c:\drivers.  I use Windows 7, so I imagine I need that folder.  I also have folders with some duplicate drivers:  \documents\double driver backup and \dell\drivers. 
Do I need those last two?

A:Duplicate drivers; which folder(s) can I delete?

You should keep the c:\drivers.  You can delete the others, but if you need to delete because you are running low on hard drive space you really need to install a larger hard drive.  Considering the price of hard drives, now, there is no reason to have to delete, etc, because of drive space.

Read other 4 answers
RELEVANCY SCORE 50

I reinstalled XP Pro to another directory and now I have two installed. How do I delete the original operating system in the Windows folder. It tells me it is a system folder and will not let me delete it.

Thanks
Donald Spinks
 

A:how do i delete duplicate operating systems

You should be able to delete the folder unless some of your programs are using it.

If you are using a FAT32 file system use a Dos boot disk to access the command prompt and delete the folder from there.

If you are using NTFS then use the recovery console to delete it.
 

Read other 1 answers
RELEVANCY SCORE 50

I ran CCleaner and it found lots of duplicate files on my laptop. Should i delete the duplicates?

A:should i delete duplicate files on my computer?

Hi, That is one of the weak part of Windows - and other software. Each software creates its own folder and it normally uses that folder to run. Windows should be smart enough to store common files in only one spot but it can't work this out ! You can delete them BUT please note them where they are because you may have restore them back for other programs. My suggestion: keep them, few hundred megabytes now are just a piece of cake. Regards.

Read other 5 answers
RELEVANCY SCORE 50

I think I downloaded a .reg file from internet that created double system folders in my computer but I can't remember. They seem to be an extra music, videos, documents, pictures and downloads folder but I cannot put any files in the folder. Anyone know how to delete them? There's also a strange name in address bar when I open one of the folders. Also, when I click start and then click a folder liek videos folder then nothing happens.

A:How to delete duplicate system folders?

Hello and welcome to TenForums

There is a tutorial that describes how you can delete or restore these folders here:
This PC 'Folders' - Add or Remove in Windows 10

Might be worth trying these methods to see if you can restore them.

Read other 0 answers
RELEVANCY SCORE 50

I wonder can anyone recommend a free program out there that can find duplicate files, pictures etc on a computer? I found some but I am not sure if they are SpyFree and VirusFree.

A:How to find & delete duplicate files

Hi mamma,You can try this freeware :http://www.softpedia.com/get/System/File-M...le-Finder.shtml

Read other 5 answers
RELEVANCY SCORE 50

My PC was recently updates to WIN 7 and folders from my old XP were imported from backup. Now I have duplicates all over the place. Only my wife and I use this pc. Can anyone help me try and restore some sembelance of order to the folders/files.?

A:How to locate and delete duplicate folders

Several of us use Puran Utilities, it has that function.  Use caution with any and all downloads to avoid junk!
 
http://www.puransoftware.com/Puran-Utilities.html

Read other 4 answers
RELEVANCY SCORE 50

Hi so I was changing my password on my hotmail account.( i know old school ) My administrator account  windows is linked with my homail account. I changed the password on my mobile device. And when i turn my laptop I wasn't able to login. Therefore
I opened another account with the changed password.
Now whenever I turn on my laptop there's two administrator accounts. I'm not able to delete one of them. Please help

Read other answers
RELEVANCY SCORE 50

Hi all, sorry if this is not in the right category (it kind of mixes email and applications).

I work IT for a local school and we're moving everyone's email from Rackspace email to Gmail. The way we have everyone copying old emails over is to have them setup both accounts in Apple's Mail 6.5 program (all the teachers have Macbooks) and drag and drop from one account to the other.

Here's my concern, we have several teachers who've wound up with duplicate emails in their new Gmail inboxes. Is there a quick way to get rid of the duplicates without manually having to go through each email. Is there some trick on Gmail or a usable script on Mail 6.5 (all laptops on Mountain Lion or Snow Leopard) that will help out? Or perhaps some third party program or service? Any advice would be great. Thanks.
 

A:Quick way to delete duplicate emails?

Read other 12 answers
RELEVANCY SCORE 50

Running Windows XP Pro on several computers here. Only *one* of them has this problem:

Everytime I create a desktop icon, the computer adds a second identical icon on the desktop. The second icon can't be deleted. When I try to delete it, I get the error message "Cannot read from the source file or disk."

What gives? Any help appreciated. Thanx.
 

A:Duplicate shortcuts on desktop ... can't delete

I'm wondering if a simple scan disk won't fix the problem. ScanDisk checks your hard drive for errors and then fixes them.
 

Read other 3 answers
RELEVANCY SCORE 50

I've created a folder with shortcuts to all my songs; about 3,000 in total.
The problem is that it's created duplicate shortcuts for most songs:

How would I go about deleting the duplicates? The duplicates share the same name, just with ".lnk" at the end.

I've tried using the following AutoHotkey scripts but none of these worked, they ended up deleting every file in the folder.
FileDelete, F:\Music\myshortcuts\*lnk*.*
FileDelete, F:\Music\myshortcuts\*.lnk
FileDelete, F:\Music\myshortcuts\*lnk*

Any suggestions? Thanks.

A:How to mass delete duplicate shortcuts?

Would *mp3.ink work?

Read other 2 answers
RELEVANCY SCORE 50

please delete this is duplicate post.

Read other answers
RELEVANCY SCORE 50

My ie "favorites" bookmarks are endlessly duplicating and cannot be deleted.  Is there any way to save my bookmarks and get rid of the copies?   

A:Duplicate ie favorites files - cannot delete

Click start, run, type %userprofile%\Favorites and press enter. See what's going on in there with Windows Explorer.

Read other 13 answers
RELEVANCY SCORE 49.6

I am wondering whether anyone knows of a good utility that can search through your address book in Outlook Express 6 and delete duplicate entries?

Many thanks in advance...
 

A:Utility that will delete duplicate address entries in OE 6?

Hi jeremywms

Can't speak for any of them, here are a few I found:
http://www.snapfiles.com/downloadfind.php?action=s&st=remove+duplicate+e-mail+accounts
 

Read other 3 answers
RELEVANCY SCORE 49.6

Hi All,

I have a few macros in Normal.dot including some which load a new letter with different Headers and Footers for business letters and personal letters.

I have assigned buttons for the macros BUS HOM BEN

When I click &quot;New&quot; in the menu I get a new page using the Normal.dot template showing my Macros.
BUS - HOM - BEN

Now, if I click the button for the &quot;Business Macro&quot; = BUS, I get the correct new letter with Business header, but now it has duplicate Macros as in....
BUS - HOM - BEN - BUS - HOM - BEN

I go to the Customize menu and in the Macro list it shows them duplicated, no surprise there.

How can I delete the excess Macros?

Thanks
 

Read other answers