Deleting Duplicate Rows with vba

Hi, Jaslake,
Here are the additional files you requested. I appreciate all your help.
Lin

I think I deleted my original post when adding new documents. Here was the original post:

Hi, I have this worksheet that I have VBA to consolidate 14 logbooks into this one master logbook (attached). You can view the code there if needed.
On Sheet 1 I have made two buttons. One is called "Reorder Date of Hearing" and the other is "Consolidate Logbooks." Both of these work fine.

I would like to add a third button to delete duplicate rows once I consolidate the logbooks. I am having trouble finding this code on line and adapting it to my needs.

Hope someone can help.

Each row could have duplicate dates, board numbers and employees, etc. That's okay. But when I consolidate the logbooks on a continual basis, the previous info in the logbooks then gets dumped into the master logbook creating duplicates. Hope that makes sense. In other words, my vba code doesn't add only NEW data to the master logbook as each logbook is updated. The vba takes the old and new data and consolidates it all over again and adding on to the previous data in the master logbook.

I guess I have two options:
1) write another vba to find the duplicates that were added on which I can’t seem to figure out
2) add vba to the already "consolidated logbooks" button to only add new data from the 14 logbooks. Then I am wondering how if changes were made to existing info how that would transferred to the master logbook? This I also don’t know how to do.

Ughh. I am very new to this and have made this worksheet by googling and youtube so hopefully someone can help me with this
Any help would be appreciated.
Lin

Hi Scrapnforfun

The way I usually approach this issue (prevent posting previously processed Data) is to add a Column to each of the 14 Log Books. Label the Column "Processed".

In your Code, as each individual Log Book is processed...

• Place an "X" in this "Processed" Column.
• Filter on this "Processed" Column for "Blanks"; process only those Filtered Rows.

It's pretty straight forward.

If you need help with the Code add a couple of individual Log Books (with Data) to your Thread...one of us will assist.

Hi Scrapnforfun

No need to apologize...you don't need to follow yet...you will eventually.

I must ask...why is there Code in all the Workbooks? Seems there should be Code only in Workbook Logbook Master.xlsm.
I'm going to pursue this for a bit tonight...have an appointment in the AM. I THINK I understand what you're trying to accomplish...get back to you in a bit.

Hi Lin

We'll fix it...won't be tonight...gotta get to bed...stuff in the AM...

Hi,
Sorry I didn't reply back last night. My daughter had something going on I needed to help her with.
I appreciate any help you can give whenever I have been working on this for days, full days so it is much appreciated.
I have code in all workbooks for the button "Reorder Hearing Date." When we enter files individually, we may enter them out of date sequence so I have the code to reorder the hearing date from past to current.

Then the master logbook has that same code so when I then combine all the workbooks, the master logbook can reorder the hearing dates from all the individual logbooks. The master logbook also has the code to now combine all these logbooks. So that's two codes for the master logbook and one code for each individual logbook. If there is any other code or modules, that's because I was trying to fiddle around and figure out how to get rid of duplicates. My "Remove Duplicates" button does not work in my version of 2010. Once in a while it will but then doesn't, so I don't trust it. That's why I have this dilemma in trying to either get another vba code in there to delete duplicates or add to the existing master logbook code with maybe something that will only add in new data from each logbook.

Maybe my code in the master logbook can be expounded upon to just add in new transferred data from each individual logbook. I don't know. That's beyond me.

Thanks again. Have a successful appointment today!
Lin

PS: There may be an easier solution to accomplish all this, but with my inexperience, I may have made this more complicated. I have so say, though, all the help on this forum and videos is what got me to this point, and I appreciate all that have helped me!!!

Hi Lin

This Code in the attached assumes the Log Book Master and the 14 individual Log Books are in the same Folder...matters not where.
If this is not the case let me know.

The Code will open each individual Log Book and populate Log Book Master with the "Unprocessed" items from the individual Log Books.

Please Login or Register  to view this content.

Hi Lin

In a word...No...that's a completely different process.

Does that also update if someone were to make a change to something that was already "processed"? Say they changed a date or misspelled the person's name and corrected it. Would that correction then get changed on the master?

You're welcome...glad I could help. Thanks for the Rep.

Hi Lin

The only way to do this that comes to mind given your File Structure and the number of Files involved would be to create a Cross Reference between the Master and the individual Log Books at such time as records are processed. Were the User to change a record on the individual Log Book the "X" would get cleared and the record would get replaced in the Master by the changed individual Log File record. All a bit messy...and requires discipline...

If you're interested create a new Thread for this issue...PM me with a Link if you wish.

Hi Lin

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Hi Lin

Seems we discussed this same issue in responses 12-16...is it different?

I was hoping you could help a little more with this spreadsheet. I've been using it for a bit and it is great except if a half a line was filled in on the individual logbook and then they come back a few days later and finish filling in the same line but it was "processed" before they came back to finish the line, is there any way to have the rest of the data entered transfered to the master logbook when I hit the "consolidate logbooks" button? It is just that I would like to use the logbook master as the go-to logbook, and I wouldn't know if someone changed something or added to a line in their individual logbook once it is processed because it won't show up in the logbook master. Is this doable?

My response to you at that time was...

The only way to do this that comes to mind given your File Structure and the number of Files involved would be to create a Cross Reference between the Master and the individual Log Books at such time as records are processed. Were the User to change a record on the individual Log Book the "X" would get cleared and the record would get replaced in the Master by the changed individual Log File record. All a bit messy...and requires discipline...

If the same issue as described you'll need to start a new Thread...