Macro Multi Sheet Duplicate Copy to New Sheet

[Digital_Warrior]

I am trying to copy Duplicates rows from sheet Master column F and sheet Incoming column F, into sheet Duplicates. The data in column F is numbers. This is code that I had found on this site during a preivous search. Excel 2010

This is what I have so far and well it is broke, the result is Excel has to be forced closed.

Please Login or Register  to view this content.

Thank you in advance for your assistance and guidance.

DW

[xladept]

Please Login or Register  to view this content.

??

[Digital_Warrior]

I do not have a clue. I am starting to learn VBA on the fly. I had found the code on this site earlier (wish I would have saved the page).
Where I am trying to go with all of this. Is that what is left is Master is items that have been removed, while the items left in Import are new items. The Duplicate sheet will only contain one copy of the duplicate not both rows from Master and Import. I want to copy the left over rows from Master into a sheet called Removed. I want to copy the left over rows in Import to a sheet called New Items where I will perform some more manipulation to them ie. assigning department ect. Count up the rows from master that were removed and record that number in a sheet called Tracking with date stamp. Doing the same for Import. Wiping clean Master and Import. Copy Duplicates (should be unique values) and Import back to master and wipe duplicates and Import.

I hope this helps as I am as lost as can be at this point. Getting the import to work was easy, removing the temporary file that was download after import was easy. I just do not know how to proceed from here. Your help is greatly appreciated and I hope that I can learn from all of this.

[xladept]

Hey DW,

I meant that you should change that line and try it

[Digital_Warrior]

Let me give it a try. Will get back with you.

[xladept]

Hey DW,

Correction - Change both of those lines!

[Digital_Warrior]

Ok made the change. Still locks up excel. If I step threw the the code. in the third (Dup Sheet) in cell F2 it puts the first sheet f2, if we continue to step threw it just over wrights with f3, f4, ect. I have attached an example now that I am not at work.

example.xlsm

[Digital_Warrior]

Missed your post. Changing the second one does not help.

[xladept]

This works:

Please Login or Register  to view this content.

[Digital_Warrior]

It works great. I tried putting in

Please Login or Register  to view this content.

after

Please Login or Register  to view this content.

To remove the rows from the first two sheets. Odd resuslts. it removed every other row in the fist two sheets and added every other row to the third. How would one go about doing it.

[xladept]

Something like this:

Please Login or Register  to view this content.

Let me know if it works - the problem is that when you're using For Each...Next - you can't delete anything during the process - and it's practically impossible to index the deletions in ascending mode - everyone always deletes descending after it's all over

Here's a better way - I hope:

Please Login or Register  to view this content.

[Digital_Warrior]

The first one was a bust.
The second one works almost. I just ran it on a copy of my live system 600 records per sheet. I ened up with 3 rows that where not copied over to Duplicates and left in Master sheet and Incoming.
Thank you DW

EDIT Figured out the Issue. During export of the imcomming data. The data in column F is stored as number as txt. Is there a way to convert column from number stored at txt to just a normal number, decimal places of 0. The first Duplicate is not moved into Duplicates and not removed from master and Import.

Thanks again DW.

[xladept]

Maybe:

Please Login or Register  to view this content.

[Digital_Warrior]

Sorry got pulled into diffrent project for a bit.
With the Chage to IF C*1 = A*1 I recive a Run-time error 13 Type mismatch.

I know this has been a pain for you. Thank you for your help.