How would i delete duplicate values which consist of a row without deleting the blank rows and formating of my rows?
Using the Delete duplicate, it deletes the duplicates (great) but then it also delets the rest of my sheet that was formated with certain colors, etc
Any help/suggestions would be greatly appreciated!
Thanks,
Clint
Last edited by clintandcaden; 09-18-2012 at 11:34 AM. Reason: solved
On your "Job List Tracker" sheet, there don't seem to be any duplicates (I was looking at W/O#'s). So you want to clear contents rather than delete?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thnkyou for replying. You have to run the Macro titled WO_Numbers. That will copy all the jobs that are ready to schedule into sheet 2 but if i were to add more data onto sheet1 the next day and then run the macro again it copys the old ones and the new ones to sheet2, therefore creating duplicates onto sheet2. Sorry i didn't explain further in my first post. Yes clearing the contents on sheet2 will work, but i changed it on mine (not on the one i uploaded) excel was counting the color as a value, thus deleting it. so i just took the colors off the second sheet. If i were able to keep the colors then that would be great, but thats not my main concern now. Now it would be as I stated above. Possibly Making the Macro not copy the ones it has already put on sheet2 somehow if possible...Originally Posted by ChemistB
Last edited by clintandcaden; 09-17-2012 at 01:20 PM.
Hi clintandcaden
This code is in the attached...it appears to do as you require. Click the Button to run. Let me know of issues.
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Wow thanks!! that worked perfectly from what i can tell on this school computer. When i get to work in the morning i will double check but so far so good. You have saved my brain alot of trouble. I will change this post to SOLVED after i double check in the morning.
THANKYOU jaslake!
thanks for the help jaslake, I am getting Run Time Error '1004'
The error is at the .ShowAllDataPlease Login or Register to view this content.
AND UPON FURTHER INSPECTION THE MORE I RUN AND TEST IT THE ERROR GOES AWAY. BUT THE INITIAL OPENING AND RUNNING OF IT GIVES THAT ERROR
Last edited by clintandcaden; 09-18-2012 at 08:08 AM.
Hi Clint,
You need to add a column "X" in Col I. Jaslake's macro uses that to track which W/O's are in sheet 2. Take a look at his upload in post 4
.
thank both of you for the help. It is greatly appreciated
Hi clintandcaden
You're welcome...glad I could help.
@ChemistB
Thanks for explaining about Header I...I should have mentioned that and failed to.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks